SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for $prefix$admin
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$admin`;
CREATE TABLE `$prefix$admin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `seller_id` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '商户ID',
  `group` tinyint(1) DEFAULT '2' COMMENT '管理员分组 super- admin 和 admin',
  `name` varchar(40) DEFAULT '' COMMENT '管理员名称',
  `account` varchar(80) DEFAULT '' COMMENT '登录账号',
  `last_login_time` int(10) unsigned DEFAULT NULL COMMENT '最后登录时间',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态 1 正常 2 禁用',
  `password` varchar(255) DEFAULT '' COMMENT '密码',
  `is_del` tinyint(1) DEFAULT '1' COMMENT '删除 1 正常 2 删除',
  `delete_time` int(10) unsigned DEFAULT NULL,
  `create_time` int(10) unsigned DEFAULT NULL,
  `update_time` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管理员表';

-- ----------------------------
-- Records of $prefix$admin
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$admin_login_log
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$admin_login_log`;
CREATE TABLE `$prefix$admin_login_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '登录日志ID',
  `seller_id` int(11) NOT NULL DEFAULT '1',
  `title` varchar(80) DEFAULT '' COMMENT '内容',
  `admin_id` int(11) DEFAULT NULL COMMENT '管理员ID',
  `admin_name` varchar(120) DEFAULT '' COMMENT '管理员名称',
  `ip` varchar(80) DEFAULT NULL COMMENT '登录IP',
  `addr` varchar(80) DEFAULT '' COMMENT '登陆地点',
  `login_time` int(11) DEFAULT NULL COMMENT '登录时间',
  `agent` varchar(255) DEFAULT '' COMMENT '客户端',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='登录日志';

-- ----------------------------
-- Records of $prefix$admin_login_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$admin_menu`;
CREATE TABLE `$prefix$admin_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '后台菜单ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父菜单id',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '菜单类型;1:有界面可访问菜单,2:无界面可访问菜单,3:只作为菜单',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:正常,2:禁用',
  `sort` smallint(6) NOT NULL DEFAULT '10000' COMMENT '排序',
  `controller` varchar(120) NOT NULL DEFAULT '' COMMENT '控制器名',
  `action` varchar(120) NOT NULL DEFAULT '' COMMENT '操作名称',
  `param` varchar(120) NOT NULL DEFAULT '' COMMENT '额外参数',
  `path` varchar(255) DEFAULT '' COMMENT '访问地址',
  `title` varchar(120) NOT NULL DEFAULT '' COMMENT '菜单名称',
  `icon` varchar(120) NOT NULL DEFAULT '' COMMENT '菜单图标',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `is_menu` tinyint(3) unsigned DEFAULT '1',
  `is_del` tinyint(1) NOT NULL DEFAULT '1' COMMENT '删除 1 正常 2 删除',
  `delete_time` int(11) NOT NULL DEFAULT '0',
  `create_time` int(11) NOT NULL DEFAULT '0',
  `update_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `status` (`status`) USING BTREE,
  KEY `parent_id` (`parent_id`) USING BTREE,
  KEY `controller` (`controller`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8mb4 COMMENT='后台菜单表';

-- ----------------------------
-- Records of $prefix$admin_menu
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$admin_menu` VALUES (1, 1, 0, 1, 1, 1, '', '', '', '', '系统管理', '', '', 1, 1, 0, 1633486619, 1633486619);
INSERT INTO `$prefix$admin_menu` VALUES (2, 1, 1, 2, 1, 11, 'SysSetting', 'dashbord', '', '/SysSetting/dashbord', '控制面板', 'icon-kongzhimianban', '', 1, 1, 0, 1633486674, 1633486674);
INSERT INTO `$prefix$admin_menu` VALUES (3, 1, 1, 2, 1, 12, 'SysSetting', 'index', '', '/SysSetting/index', '系统设置', 'icon-xitongshezhi', '', 1, 1, 0, 1633486794, 1633486794);
INSERT INTO `$prefix$admin_menu` VALUES (4, 1, 3, 1, 1, 31, 'SysSetting', 'update', '', '/SysSetting/update', '系统邮件设置保存', '', '', 2, 1, 0, 1633486902, 1633486902);
INSERT INTO `$prefix$admin_menu` VALUES (5, 1, 3, 1, 1, 32, 'SysSetting', 'update', '', '/SysSetting/update', '系统上传设置保存', '', '', 2, 1, 0, 1633486980, 1633486980);
INSERT INTO `$prefix$admin_menu` VALUES (6, 1, 3, 1, 1, 33, 'SysSetting', 'update', '', '/SysSetting/update', '系统统计分析设置保存', '', '', 2, 1, 0, 1633487008, 1633487008);
INSERT INTO `$prefix$admin_menu` VALUES (7, 1, 1, 1, 1, 13, '', '', '', '', '管理员权限', 'icon-guanliyuanquanxian', '', 1, 1, 0, 1633487076, 1633487076);
INSERT INTO `$prefix$admin_menu` VALUES (8, 1, 7, 2, 1, 71, 'Admin', 'index', '', '/Admin/index', '管理员管理', '', '', 1, 1, 0, 1633487110, 1633487110);
INSERT INTO `$prefix$admin_menu` VALUES (9, 1, 8, 1, 1, 81, 'Admin', 'save', '', '/Admin/save', '管理员添加', '', '', 2, 1, 0, 1633487146, 1633487146);
INSERT INTO `$prefix$admin_menu` VALUES (10, 1, 8, 1, 1, 82, 'Admin', 'update', '', '/Admin/update', '管理员编辑', '', '', 2, 1, 0, 1633487161, 1633487161);
INSERT INTO `$prefix$admin_menu` VALUES (11, 1, 8, 1, 1, 83, 'Admin', 'delete', '', '/Admin/delete', '管理员删除', '', '', 2, 1, 0, 1633487171, 1633487171);
INSERT INTO `$prefix$admin_menu` VALUES (12, 1, 7, 2, 1, 72, 'Role', 'index', '', '/Role/index', '角色管理', '', '', 1, 1, 0, 1633487327, 1633487327);
INSERT INTO `$prefix$admin_menu` VALUES (13, 1, 12, 1, 1, 121, 'Role', 'save', '', '/Role/save', '角色添加', '', '', 2, 1, 0, 1633487354, 1633487354);
INSERT INTO `$prefix$admin_menu` VALUES (14, 1, 12, 1, 1, 122, 'Role', 'update', '', '/Role/update', '角色编辑', '', '', 2, 1, 0, 1633487373, 1633487373);
INSERT INTO `$prefix$admin_menu` VALUES (15, 1, 12, 1, 1, 123, 'Role', 'delete', '', '/Role/delete', '角色删除', '', '', 2, 1, 0, 1633487391, 1633487391);
INSERT INTO `$prefix$admin_menu` VALUES (16, 1, 8, 1, 1, 84, 'Admin', 'read', '', '/Admin/read', '管理员详情', '', '', 2, 1, 0, 1633487423, 1633487423);
INSERT INTO `$prefix$admin_menu` VALUES (17, 1, 1, 2, 1, 14, 'Attachment', 'index', '', '/Attachment/index', '附件管理', 'icon-fujianguanli', '', 2, 1, 0, 1633487558, 1633487558);
INSERT INTO `$prefix$admin_menu` VALUES (18, 1, 1, 1, 1, 171, 'Attachment', 'save', '', '/Attachment/save', '附件添加', '', '', 2, 1, 0, 1633487586, 1633487586);
INSERT INTO `$prefix$admin_menu` VALUES (19, 1, 1, 1, 1, 172, 'Attachment', 'delete', '', '/Attachment/delete', '附件删除', '', '', 2, 1, 0, 1633487603, 1633487603);
INSERT INTO `$prefix$admin_menu` VALUES (20, 1, 1, 1, 1, 15, '', '', '', '//', '日志管理', 'icon-rizhiguanli', '', 1, 1, 0, 1633487634, 1633487634);
INSERT INTO `$prefix$admin_menu` VALUES (21, 1, 20, 2, 1, 201, 'AdminLoginLog', 'index', '', '/AdminLoginLog/index', '登录日志', '', '', 1, 1, 0, 1633487666, 1633487666);
INSERT INTO `$prefix$admin_menu` VALUES (22, 1, 20, 2, 1, 202, 'AdminOptLog', 'index', '', '/AdminOptLog/index', '操作日志', '', '', 1, 1, 0, 1633487695, 1633487695);
INSERT INTO `$prefix$admin_menu` VALUES (23, 1, 1, 2, 1, 16, 'RecycleBin', 'index', '', '/RecycleBin/index', '回收站管理', 'icon-huishouzhanguanli', '', 1, 1, 0, 1633487783, 1633487783);
INSERT INTO `$prefix$admin_menu` VALUES (24, 1, 23, 1, 1, 231, 'RecycleBin', 'clean', '', '/RecycleBin/clean', '回收站清空', '', '', 2, 1, 0, 1633487824, 1633487824);
INSERT INTO `$prefix$admin_menu` VALUES (25, 1, 23, 1, 1, 232, 'RecycleBin', 'delete', '', '/RecycleBin/delete', '回收站删除', '', '', 2, 1, 0, 1633487841, 1633487841);
INSERT INTO `$prefix$admin_menu` VALUES (26, 1, 23, 1, 1, 233, 'RecycleBin', 'restore', '', '/RecycleBin/restore', '单条数据恢复', '', '', 2, 1, 0, 1633487920, 1633487920);
INSERT INTO `$prefix$admin_menu` VALUES (27, 1, 23, 1, 1, 234, 'RecycleBin', 'allRestore', '', '/RecycleBin/allRestore', '多条数据恢复', '', '', 2, 1, 0, 1633487940, 1633487940);
INSERT INTO `$prefix$admin_menu` VALUES (28, 1, 1, 2, 1, 17, 'Database', 'index', '', '/Database/index', '数据库备份', 'icon-shujukubeifen', '', 1, 1, 0, 1633487973, 1633487973);
INSERT INTO `$prefix$admin_menu` VALUES (29, 1, 28, 1, 1, 281, 'Database', 'backup', '', '/Database/backup', '备份数据库', '', '', 2, 1, 0, 1633488085, 1633488085);
INSERT INTO `$prefix$admin_menu` VALUES (30, 1, 28, 1, 1, 282, 'Database', 'restore', '', '/Database/restore', '数据库还原', '', '', 2, 1, 0, 1633488174, 1633488174);
INSERT INTO `$prefix$admin_menu` VALUES (31, 1, 28, 1, 1, 283, 'Database', 'delete', '', '/Database/delete', '备份文件删除', '', '', 2, 1, 0, 1633488191, 1633488191);
INSERT INTO `$prefix$admin_menu` VALUES (32, 1, 0, 1, 1, 2, '', '', '', '//', '网站管理', '', '', 1, 1, 0, 1633488240, 1633488240);
INSERT INTO `$prefix$admin_menu` VALUES (33, 1, 32, 2, 1, 321, 'Website', 'index', '', '/Website/index', '网站列表', 'icon-zhandianliebiao', '', 1, 1, 0, 1633488270, 1633488270);
INSERT INTO `$prefix$admin_menu` VALUES (34, 1, 33, 1, 1, 331, 'Website', 'save', '', '/Website/save', '网站添加', '', '', 2, 1, 0, 1633488296, 1633488296);
INSERT INTO `$prefix$admin_menu` VALUES (35, 1, 33, 1, 1, 332, 'Website', 'update', '', '/Website/update', '网站编辑', '', '', 2, 1, 0, 1633488317, 1633488317);
INSERT INTO `$prefix$admin_menu` VALUES (36, 1, 33, 1, 1, 333, 'Website', 'delete', '', '/Website/delete', '网站删除', '', '', 2, 1, 0, 1633488416, 1633488416);
INSERT INTO `$prefix$admin_menu` VALUES (37, 1, 32, 2, 1, 322, 'WebsiteSetting', 'index', '', '/WebsiteSetting/index', '网站基本设置', 'icon-wangzhanjibenshezhi', '', 1, 1, 0, 1633488480, 1633488480);
INSERT INTO `$prefix$admin_menu` VALUES (38, 1, 37, 1, 1, 371, 'WebsiteSetting', 'update', '', '/WebsiteSetting/update', '基本设置保存', '', '', 2, 1, 0, 1633488542, 1633488542);
INSERT INTO `$prefix$admin_menu` VALUES (39, 1, 37, 1, 1, 372, 'WebsiteLang', 'update', '', '/WebsiteLang/update', '语言设置保存', '', '', 2, 1, 0, 1633488558, 1633488558);
INSERT INTO `$prefix$admin_menu` VALUES (40, 1, 37, 1, 1, 373, 'WebsiteLang', 'update', '', '/WebsiteLang/update', '服务器设置保存', '', '', 2, 1, 0, 1633488569, 1633488569);
INSERT INTO `$prefix$admin_menu` VALUES (41, 1, 32, 1, 1, 323, '', '', '', '//', '网站模版管理', 'icon-wangzhanmobanguanli', '', 1, 1, 0, 1633488609, 1633488609);
INSERT INTO `$prefix$admin_menu` VALUES (42, 1, 41, 2, 1, 411, 'TempleteLibrary', 'index', '', '/TempleteLibrary/index', '模版库', '', '', 1, 1, 0, 1633488696, 1633488696);
INSERT INTO `$prefix$admin_menu` VALUES (43, 1, 41, 2, 1, 422, 'Theme', 'index', '', '/Theme/index', '模版管理', '', '', 1, 1, 0, 1633519385, 1633519385);
INSERT INTO `$prefix$admin_menu` VALUES (44, 1, 43, 1, 2, 431, 'Theme', 'save', '', '/Theme/save', '模版下载', '', '', 2, 1, 0, 1633519412, 1633519412);
INSERT INTO `$prefix$admin_menu` VALUES (45, 1, 43, 1, 1, 432, 'Theme', 'update', '', '/Theme/update', '模版更新', '', '', 2, 1, 0, 1633519424, 1633519424);
INSERT INTO `$prefix$admin_menu` VALUES (46, 1, 43, 1, 1, 432, 'Theme', 'delete', '', '/Theme/delete', '模版删除', '', '', 2, 1, 0, 1633519439, 1633519439);
INSERT INTO `$prefix$admin_menu` VALUES (47, 1, 43, 1, 1, 433, 'Theme', 'install', '', '/Theme/install', '系统模版', '', '', 2, 1, 0, 1633519520, 1633519520);
INSERT INTO `$prefix$admin_menu` VALUES (48, 1, 43, 1, 1, 434, 'Theme', 'installTheme', '', '/Theme/installTheme', '模版安装', '', '', 2, 1, 0, 1633519564, 1633519564);
INSERT INTO `$prefix$admin_menu` VALUES (49, 1, 43, 1, 1, 435, 'Theme', 'active', '', '/Theme/active', '模版启用', '', '', 2, 1, 0, 1633519627, 1633519627);
INSERT INTO `$prefix$admin_menu` VALUES (50, 1, 43, 1, 1, 436, 'Theme', 'uninstall', '', '/Theme/uninstall', '模版卸载', '', '', 2, 1, 0, 1633519672, 1633519672);
INSERT INTO `$prefix$admin_menu` VALUES (51, 1, 43, 1, 1, 437, 'Theme', 'allFilePath', '', '/Theme/allFilePath', '模版文件目录', '', '', 2, 1, 0, 1633520228, 1633520228);
INSERT INTO `$prefix$admin_menu` VALUES (52, 1, 43, 1, 1, 438, 'Theme', 'allFiles', '', '/Theme/allFiles', '所有文件', '', '', 2, 1, 0, 1633520293, 1633520293);
INSERT INTO `$prefix$admin_menu` VALUES (53, 1, 43, 1, 1, 439, 'Theme', 'tmpFile', '', '/Theme/tmpFile', '模版文件', '', '', 2, 1, 0, 1633520353, 1633520353);
INSERT INTO `$prefix$admin_menu` VALUES (54, 1, 53, 1, 1, 531, 'ThemeFile', 'read', '', '/ThemeFile/read', '模版文件源码查看', '', '', 2, 1, 0, 1633520526, 1633520526);
INSERT INTO `$prefix$admin_menu` VALUES (55, 1, 53, 1, 1, 532, 'ThemeFile', 'update', '', '/ThemeFile/update', '模版文件源码更新', '', '', 2, 1, 0, 1633520662, 1633520662);
INSERT INTO `$prefix$admin_menu` VALUES (56, 1, 32, 1, 1, 324, '', '', '', '//', '内容管理', 'icon-neirongguanli', '', 1, 1, 0, 1633521143, 1633521143);
INSERT INTO `$prefix$admin_menu` VALUES (57, 1, 56, 2, 1, 561, 'Module', 'index', '', '/Module/index', '模型管理', '', '', 1, 1, 0, 1633521177, 1633521177);
INSERT INTO `$prefix$admin_menu` VALUES (58, 1, 57, 1, 1, 571, 'Module', 'save', '', '/Module/save', '模型添加', '', '', 2, 1, 0, 1633521229, 1633521229);
INSERT INTO `$prefix$admin_menu` VALUES (59, 1, 57, 1, 1, 572, 'Module', 'update', '', '/Module/update', '模型编辑', '', '', 2, 1, 0, 1633521245, 1633521245);
INSERT INTO `$prefix$admin_menu` VALUES (60, 1, 57, 1, 1, 573, 'Module', 'delete', '', '/Module/delete', '模型删除', '', '', 2, 1, 0, 1633521264, 1633521264);
INSERT INTO `$prefix$admin_menu` VALUES (61, 1, 57, 1, 1, 574, 'Module', 'read', '', '/Module/read', '模型详情', '', '', 2, 1, 0, 1633521275, 1633521275);
INSERT INTO `$prefix$admin_menu` VALUES (62, 1, 56, 1, 1, 562, 'ModuleField', 'index', '', '/ModuleField/index', '模型字段', '', '', 2, 1, 0, 1633525422, 1633525422);
INSERT INTO `$prefix$admin_menu` VALUES (63, 1, 62, 1, 1, 621, 'ModuleField', 'save', '', '/ModuleField/save', '模型字段添加', '', '', 2, 1, 0, 1633525442, 1633525442);
INSERT INTO `$prefix$admin_menu` VALUES (64, 1, 62, 1, 1, 622, 'ModuleField', 'update', '', '/ModuleField/update', '模型字段编辑', '', '', 2, 1, 0, 1633525464, 1633525464);
INSERT INTO `$prefix$admin_menu` VALUES (65, 1, 62, 1, 1, 623, 'ModuleField', 'delete', '', '/ModuleField/delete', '模型字段删除', '', '', 2, 1, 0, 1633525481, 1633525481);
INSERT INTO `$prefix$admin_menu` VALUES (66, 1, 62, 1, 1, 624, 'ModuleField', 'read', '', '/ModuleField/read', '模型字段详情', '', '', 2, 1, 0, 1633525499, 1633525499);
INSERT INTO `$prefix$admin_menu` VALUES (67, 1, 56, 2, 1, 563, 'Category', 'index', '', '/Category/index', '栏目管理', '', '', 1, 1, 0, 1633525698, 1633525698);
INSERT INTO `$prefix$admin_menu` VALUES (68, 1, 67, 1, 1, 671, 'Category', 'save', '', '/Category/save', '栏目添加', '', '', 2, 1, 0, 1633525723, 1633525723);
INSERT INTO `$prefix$admin_menu` VALUES (69, 1, 67, 1, 1, 672, 'Category', 'update', '', '/Category/update', '栏目编辑', '', '', 2, 1, 0, 1633525736, 1633525736);
INSERT INTO `$prefix$admin_menu` VALUES (70, 1, 67, 1, 1, 673, 'Category', 'delete', '', '/Category/delete', '栏目删除', '', '', 2, 1, 0, 1633525786, 1633525786);
INSERT INTO `$prefix$admin_menu` VALUES (71, 1, 133, 1, 1, 1331, 'Content', 'save', '', '/Content/save', '内容新增', '', '', 2, 1, 0, 1633526383, 1633526383);
INSERT INTO `$prefix$admin_menu` VALUES (72, 1, 133, 1, 1, 1332, 'Content', 'update', '', '/Content/update', '内容编辑', '', '', 2, 1, 0, 1633526396, 1633526396);
INSERT INTO `$prefix$admin_menu` VALUES (73, 1, 133, 1, 1, 1333, 'Content', 'delete', '', '/Content/delete', '内容删除', '', '', 2, 1, 0, 1633526428, 1633526428);
INSERT INTO `$prefix$admin_menu` VALUES (74, 1, 56, 2, 1, 565, 'Tag', 'index', '', '/Tag/index', '标签管理', '', '', 1, 1, 0, 1633526488, 1633526488);
INSERT INTO `$prefix$admin_menu` VALUES (75, 1, 74, 1, 1, 741, 'Tag', 'save', '', '/Tag/save', '标签添加', '', '', 2, 1, 0, 1633526511, 1633526511);
INSERT INTO `$prefix$admin_menu` VALUES (76, 1, 74, 1, 1, 742, 'Tag', 'update', '', '/Tag/update', '标签编辑', '', '', 2, 1, 0, 1633526537, 1633526537);
INSERT INTO `$prefix$admin_menu` VALUES (77, 1, 74, 1, 1, 743, 'Tag', 'delete', '', '/Tag/delete', '标签删除', '', '', 2, 1, 0, 1633526544, 1633526544);
INSERT INTO `$prefix$admin_menu` VALUES (78, 1, 32, 1, 1, 326, 'Nav', 'index', '', '/Nav/index', '菜单列表', '', '', 2, 1, 0, 1633526626, 1633526626);
INSERT INTO `$prefix$admin_menu` VALUES (79, 1, 78, 1, 1, 781, 'Nav', 'save', '', '/Nav/save', '菜单添加', '', '', 2, 1, 0, 1633526648, 1633526648);
INSERT INTO `$prefix$admin_menu` VALUES (80, 1, 78, 1, 1, 782, 'Nav', 'update', '', '/Nav/update', '菜单编辑', '', '', 2, 1, 0, 1633526661, 1633526661);
INSERT INTO `$prefix$admin_menu` VALUES (81, 1, 78, 1, 1, 783, 'Nav', 'delete', '', '/Nav/delete', '菜单删除', '', '', 2, 1, 0, 1633526675, 1633526675);
INSERT INTO `$prefix$admin_menu` VALUES (82, 1, 32, 2, 1, 325, 'NavCate', 'index', '', '/NavCate/index', '前台菜单管理', 'icon-qiantaicaidanguanli', '', 1, 1, 0, 1633526770, 1633526770);
INSERT INTO `$prefix$admin_menu` VALUES (83, 1, 82, 1, 1, 821, 'NavCate', 'save', '', '/NavCate/save', '分类添加', '', '', 2, 1, 0, 1633526884, 1633526884);
INSERT INTO `$prefix$admin_menu` VALUES (84, 1, 82, 1, 1, 822, 'NavCate', 'update', '', '/NavCate/update', '分类编辑', '', '', 2, 1, 0, 1633526890, 1633526890);
INSERT INTO `$prefix$admin_menu` VALUES (85, 1, 82, 1, 1, 823, 'NavCate', 'delete', '', '/NavCate/delete', '分类删除', '', '', 2, 1, 0, 1633526900, 1633526900);
INSERT INTO `$prefix$admin_menu` VALUES (86, 1, 0, 1, 1, 3, '', '', '', '//', '询盘管理', '', '', 1, 1, 0, 1633527118, 1633527118);
INSERT INTO `$prefix$admin_menu` VALUES (87, 1, 86, 2, 1, 861, 'Inquiry', 'index', '', '/Inquiry/index', '询盘列表', 'icon-xunpanliebiao', '', 1, 1, 0, 1633527207, 1633527207);
INSERT INTO `$prefix$admin_menu` VALUES (88, 1, 87, 1, 1, 871, 'Inquiry', 'update', '', '/Inquiry/update', '询盘更新', '', '', 2, 1, 0, 1633527303, 1633527303);
INSERT INTO `$prefix$admin_menu` VALUES (89, 1, 87, 1, 1, 872, 'Inquiry', 'delete', '', '/Inquiry/delete', '询盘删除', '', '', 2, 1, 0, 1633527326, 1633527326);
INSERT INTO `$prefix$admin_menu` VALUES (90, 1, 86, 2, 1, 862, 'InquiryCate', 'index', '', '/InquiryCate/index', '询盘分类', 'icon-xunpanfenlei', '', 1, 1, 0, 1633527908, 1633527908);
INSERT INTO `$prefix$admin_menu` VALUES (91, 1, 90, 1, 1, 901, 'InquiryCate', 'save', '', '/InquiryCate/save', '询盘分类添加', '', '', 2, 1, 0, 1633527954, 1633527954);
INSERT INTO `$prefix$admin_menu` VALUES (92, 1, 90, 1, 1, 902, 'InquiryCate', 'update', '', '/InquiryCate/update', '询盘分类编辑', '', '', 2, 1, 0, 1633528000, 1633528000);
INSERT INTO `$prefix$admin_menu` VALUES (93, 1, 90, 1, 1, 903, 'InquiryCate', 'delete', '', '/InquiryCate/delete', '询盘分类删除', '', '', 2, 1, 0, 1633528023, 1633528023);
INSERT INTO `$prefix$admin_menu` VALUES (94, 1, 86, 2, 1, 863, 'InquiryEmail', 'index', '', '/InquiryEmail/index', '询盘收件箱', 'icon-xunpanshoujianxiang', '', 1, 1, 0, 1633528118, 1633528118);
INSERT INTO `$prefix$admin_menu` VALUES (95, 1, 94, 1, 1, 941, 'InquiryEmail', 'save', '', '/InquiryEmail/save', '询盘收件箱添加', '', '', 2, 1, 0, 1633528143, 1633528143);
INSERT INTO `$prefix$admin_menu` VALUES (96, 1, 94, 1, 1, 942, 'InquiryEmail', 'update', '', '/InquiryEmail/update', '询盘收件箱编辑', '', '', 2, 1, 0, 1633528165, 1633528165);
INSERT INTO `$prefix$admin_menu` VALUES (97, 1, 94, 1, 1, 943, 'InquiryEmail', 'delete', '', '/InquiryEmail/delete', '询盘收件箱删除', '', '', 2, 1, 0, 1633528173, 1633528173);
INSERT INTO `$prefix$admin_menu` VALUES (98, 1, 0, 1, 1, 4, '', '', '', '', '营销管理', '', '', 1, 1, 0, 1633528319, 1633528319);
INSERT INTO `$prefix$admin_menu` VALUES (99, 1, 98, 1, 1, 981, '', '', '', '', 'SEO', 'icon-SEO', '', 1, 1, 0, 1633528488, 1633528488);
INSERT INTO `$prefix$admin_menu` VALUES (100, 1, 99, 2, 1, 991, 'Keyword', 'index', '', '/Keyword/index', '关键词管理', '', '', 1, 1, 0, 1633528599, 1633528599);
INSERT INTO `$prefix$admin_menu` VALUES (101, 1, 100, 1, 1, 1001, 'Keyword', 'save', '', '/Keyword/save', '关键词添加', '', '', 2, 1, 0, 1633528624, 1633528624);
INSERT INTO `$prefix$admin_menu` VALUES (102, 1, 100, 1, 1, 1002, 'Keyword', 'update', '', '/Keyword/update', '关键词编辑', '', '', 2, 1, 0, 1633528636, 1633528636);
INSERT INTO `$prefix$admin_menu` VALUES (103, 1, 100, 1, 1, 1003, 'Keyword', 'delete', '', '/Keyword/delete', '关键词删除', '', '', 2, 1, 0, 1633528648, 1633528648);
INSERT INTO `$prefix$admin_menu` VALUES (104, 1, 99, 2, 1, 992, 'InnerChart', 'index', '', '/InnerChart/index', '内链管理', '', '', 1, 1, 0, 1633528703, 1633528703);
INSERT INTO `$prefix$admin_menu` VALUES (105, 1, 104, 1, 1, 1041, 'InnerChart', 'save', '', '/InnerChart/save', '内链添加', '', '', 2, 1, 0, 1633528729, 1633528729);
INSERT INTO `$prefix$admin_menu` VALUES (106, 1, 104, 1, 1, 1042, 'InnerChart', 'update', '', '/InnerChart/update', '内链编辑', '', '', 2, 1, 0, 1633528747, 1633528747);
INSERT INTO `$prefix$admin_menu` VALUES (107, 1, 104, 1, 1, 1043, 'InnerChart', 'delete', '', '/InnerChart/delete', '内链删除', '', '', 2, 1, 0, 1633528759, 1633528759);
INSERT INTO `$prefix$admin_menu` VALUES (108, 1, 132, 1, 1, 1321, 'Advertisement', 'save', '', '/Advertisement/save', '广告添加', '', '', 2, 1, 0, 1633528838, 1633528838);
INSERT INTO `$prefix$admin_menu` VALUES (109, 1, 132, 1, 1, 1322, 'Advertisement', 'update', '', '/Advertisement/update', '广告编辑', '', '', 2, 1, 0, 1633528863, 1633528863);
INSERT INTO `$prefix$admin_menu` VALUES (110, 1, 132, 1, 1, 1323, 'Advertisement', 'delete', '', '/Advertisement/delete', '广告删除', '', '', 2, 1, 0, 1633528914, 1633528914);
INSERT INTO `$prefix$admin_menu` VALUES (111, 1, 99, 2, 1, 994, 'Link', 'index', '', '/Link/index', '友情链接管理', '', '', 1, 1, 0, 1633528988, 1633528988);
INSERT INTO `$prefix$admin_menu` VALUES (112, 1, 111, 1, 1, 1111, 'Link', 'save', '', '/Link/save', '友情链接添加', '', '', 2, 1, 0, 1633529087, 1633529087);
INSERT INTO `$prefix$admin_menu` VALUES (113, 1, 111, 1, 1, 1112, 'Link', 'update', '', '/Link/update', '友情链接编辑', '', '', 2, 1, 0, 1633529099, 1633529099);
INSERT INTO `$prefix$admin_menu` VALUES (114, 1, 111, 1, 1, 1113, 'Link', 'delete', '', '/Link/delete', '友情链接删除', '', '', 2, 1, 0, 1633529111, 1633529111);
INSERT INTO `$prefix$admin_menu` VALUES (115, 1, 111, 1, 1, 1114, 'Link', 'copy', '', '/Link/copy', '复制其他站点友链', '', '', 2, 1, 0, 1633529250, 1633529250);
INSERT INTO `$prefix$admin_menu` VALUES (116, 1, 98, 1, 1, 982, '', '', '', '//', '统计分析', 'icon-shujufenxi', '', 1, 1, 0, 1633529747, 1633529747);
INSERT INTO `$prefix$admin_menu` VALUES (117, 1, 116, 2, 1, 1161, 'SEM', 'baidu', '', '/SEM/baidu', '百度', '', '', 1, 1, 0, 1633529780, 1633529780);
INSERT INTO `$prefix$admin_menu` VALUES (118, 1, 116, 2, 1, 1161, 'SEM', 'google', '', '/SEM/google', '谷歌', '', '', 1, 1, 0, 1633529814, 1633529814);
INSERT INTO `$prefix$admin_menu` VALUES (119, 1, 0, 1, 1, 5, '', '', '', '//', '招聘管理', '', '', 1, 1, 0, 1633529846, 1633529846);
INSERT INTO `$prefix$admin_menu` VALUES (120, 1, 119, 2, 1, 1191, 'Job', 'index', '', '/Job/index', '岗位管理', 'icon-zhiweiguanli', '', 1, 1, 0, 1633529880, 1633529880);
INSERT INTO `$prefix$admin_menu` VALUES (121, 1, 120, 1, 1, 1201, 'Job', 'save', '', '/Job/save', '岗位添加', '', '', 2, 1, 0, 1633529922, 1633529922);
INSERT INTO `$prefix$admin_menu` VALUES (122, 1, 120, 1, 1, 1202, 'Job', 'update', '', '/Job/update', '岗位编辑', '', '', 2, 1, 0, 1633529940, 1633529940);
INSERT INTO `$prefix$admin_menu` VALUES (123, 1, 120, 1, 1, 1203, 'Job', 'delete', '', '/Job/delete', '岗位删除', '', '', 2, 1, 0, 1633529954, 1633529954);
INSERT INTO `$prefix$admin_menu` VALUES (124, 1, 119, 2, 1, 1192, 'JobCate', 'index', '', '/JobCate/index', '岗位分类', 'icon-gangweifenlei', '', 1, 1, 0, 1633530098, 1633530098);
INSERT INTO `$prefix$admin_menu` VALUES (125, 1, 124, 1, 1, 1241, 'JobCate', 'save', '', '/JobCate/save', '岗位分类添加', '', '', 2, 1, 0, 1633530122, 1633530122);
INSERT INTO `$prefix$admin_menu` VALUES (126, 1, 124, 1, 1, 1242, 'JobCate', 'update', '', '/JobCate/update', '岗位分类编辑', '', '', 2, 1, 0, 1633530134, 1633530134);
INSERT INTO `$prefix$admin_menu` VALUES (127, 1, 124, 1, 1, 1243, 'JobCate', 'update', '', '/JobCate/update', '岗位分类删除', '', '', 2, 1, 0, 1633530143, 1633530143);
INSERT INTO `$prefix$admin_menu` VALUES (128, 1, 119, 2, 1, 1193, 'JobCity', 'index', '', '/JobCity/index', '城市管理', 'icon-chengshiguanli', '', 1, 1, 0, 1633530203, 1633530203);
INSERT INTO `$prefix$admin_menu` VALUES (129, 1, 128, 1, 1, 1281, 'JobCity', 'save', '', '/JobCity/save', '城市添加', '', '', 2, 1, 0, 1633530231, 1633530231);
INSERT INTO `$prefix$admin_menu` VALUES (130, 1, 128, 1, 1, 1282, 'JobCity', 'update', '', '/JobCity/update', '城市编辑', '', '', 2, 1, 0, 1633530242, 1633530242);
INSERT INTO `$prefix$admin_menu` VALUES (131, 1, 128, 1, 1, 1283, 'JobCity', 'delete', '', '/JobCity/delete', '城市删除', '', '', 2, 1, 0, 1633530261, 1633530261);
INSERT INTO `$prefix$admin_menu` VALUES (132, 1, 99, 2, 1, 993, 'Advertisement', 'index', '', '/Advertisement/index', '广告管理', '', '', 1, 1, 0, 1633531310, 1633531310);
INSERT INTO `$prefix$admin_menu` VALUES (133, 1, 56, 2, 1, 564, 'Content', 'index', '', '/Content/index', '栏目内容管理', '', '', 1, 1, 0, 1633592819, 1633592819);
INSERT INTO `$prefix$admin_menu` VALUES (134, 1, 32, 1, 1, 565, 'SlideCate', 'index', '', '/SlideCate/index', '幻灯片管理', 'icon-huandengpianshezhi', '', 1, 1, 0, 1633592819, 1633592819);
INSERT INTO `$prefix$admin_menu` VALUES (135, 1, 32, 2, 1, 566, 'Slide', 'index', '', '/Slide/index', '幻灯片列表', '', '', 2, 1, 0, 1633592819, 1633592819);
INSERT INTO `$prefix$admin_menu` VALUES (136, 1, 134, 1, 1, 1341, 'SlideCate', 'save', '', '/Slide/save', '幻灯片添加', '', '', 2, 1, 0, 1633592819, 1633592819);
INSERT INTO `$prefix$admin_menu` VALUES (137, 1, 134, 1, 1, 1342, 'SlideCate', 'update', '', '/SlideCate/update', '分类编辑', '', '', 2, 1, 0, 1633530242, 1633530242);
INSERT INTO `$prefix$admin_menu` VALUES (138, 1, 134, 1, 1, 1343, 'SlideCate', 'read', '', '/SlideCate/read', '分类详情', '', '', 2, 1, 0, 1633530242, 1633530242);
INSERT INTO `$prefix$admin_menu` VALUES (139, 1, 134, 1, 1, 1344, 'SlideCate', 'delete', '', '/SlideCate/delete', '分类删除', '', '', 2, 1, 0, 1633530242, 1633530242);
INSERT INTO `$prefix$admin_menu` VALUES (140, 1, 135, 1, 1, 1351, 'Slide', 'save', '', '/Slide/save', '幻灯片保存', '', '', 2, 1, 0, 1633530242, 1633530242);
INSERT INTO `$prefix$admin_menu` VALUES (141, 1, 135, 1, 1, 1352, 'Slide', 'update', '', '/Slide/update', '幻灯片', '', '', 2, 1, 0, 1633530242, 1633530242);
INSERT INTO `$prefix$admin_menu` VALUES (142, 1, 135, 1, 1, 1353, 'Slide', 'read', '', '/Slide/read', '幻灯片详情', '', '', 2, 1, 0, 1633530242, 1633530242);
INSERT INTO `$prefix$admin_menu` VALUES (143, 1, 135, 1, 1, 1354, 'Slide', 'delete', '', '/Slide/delete', '幻灯片删除', '', '', 2, 1, 0, 1633530242, 1633530242);
INSERT INTO `$prefix$admin_menu` VALUES (144, 1, 1, 2, 1, 14, 'AttachmentCate', 'index', '', '/AttachmentCate/index', '附件管理', 'icon-fujianguanli', '', 1, 1, 0, 1633592819, 1633592819);
INSERT INTO `$prefix$admin_menu` VALUES (145, 1, 134, 1, 1, 1441, 'AttachmentCate', 'save', '', '/AttachmentCate/save', '附件分类添加', '', '', 2, 1, 0, 1633592819, 1633592819);
INSERT INTO `$prefix$admin_menu` VALUES (146, 1, 134, 1, 1, 1442, 'AttachmentCate', 'update', '', '/AttachmentCate/update', '附件分类编辑', '', '', 2, 1, 0, 1633530242, 1633530242);
INSERT INTO `$prefix$admin_menu` VALUES (147, 1, 134, 1, 1, 1443, 'AttachmentCate', 'read', '', '/AttachmentCate/read', '附件分类详情', '', '', 2, 1, 0, 1633530242, 1633530242);
INSERT INTO `$prefix$admin_menu` VALUES (148, 1, 134, 1, 1, 1444, 'AttachmentCate', 'delete', '', '/AttachmentCate/delete', '附件分类删除', '', '', 2, 1, 0, 1633530242, 1633530242);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$admin_opt_log
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$admin_opt_log`;
CREATE TABLE `$prefix$admin_opt_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `admin_id` int(11) DEFAULT NULL,
  `admin_name` varchar(255) DEFAULT NULL,
  `title` varchar(155) DEFAULT NULL COMMENT '操作',
  `content` varchar(155) DEFAULT NULL COMMENT '操作详情',
  `ip` varchar(120) DEFAULT NULL COMMENT '操作人IP',
  `addr` varchar(255) DEFAULT NULL COMMENT '操作地点',
  `agent` varchar(255) DEFAULT NULL COMMENT '操作人客户端',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='操作日志';

-- ----------------------------
-- Records of $prefix$admin_opt_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$admin_role
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$admin_role`;
CREATE TABLE `$prefix$admin_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员角色关联表',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `role_id` int(11) DEFAULT NULL COMMENT '角色ID',
  `admin_id` int(11) DEFAULT NULL COMMENT '管理员ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管理员角色关联表';

-- ----------------------------
-- Records of $prefix$admin_role
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$advertisement
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$advertisement`;
CREATE TABLE `$prefix$advertisement` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '广告ID',
  `seller_id` int(11) DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT '0' COMMENT '站点ID',
  `type` tinyint(2) DEFAULT NULL COMMENT '广告类型 1文字 2图片 3类型',
  `title` varchar(255) DEFAULT NULL COMMENT '广告标题',
  `content` varchar(255) DEFAULT NULL COMMENT '文字内容',
  `url` varchar(255) DEFAULT NULL COMMENT '广告链接',
  `attachment_id` int(11) DEFAULT NULL COMMENT '广告附件',
  `size` varchar(255) DEFAULT NULL COMMENT '文件尺寸',
  `status` tinyint(2) DEFAULT '1' COMMENT '状态1 正常2 禁用',
  `expiration_date` date DEFAULT NULL COMMENT '有效期',
  `is_del` tinyint(1) DEFAULT '1' COMMENT '删除 1 正常 2 删除',
  `delete_time` int(11) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='广告表';

-- ----------------------------
-- Records of $prefix$advertisement
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$article
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$article`;
CREATE TABLE `$prefix$article` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `sub_title` varchar(255) DEFAULT '' COMMENT '文章副标题',
  `seller_id` bigint(20) unsigned DEFAULT NULL COMMENT '商户ID',
  `lang` varchar(255) DEFAULT 'zh' COMMENT '语言标识',
  `lang_pid` int(11) DEFAULT '0' COMMENT '语言锚点',
  `sub_id` bigint(20) unsigned DEFAULT NULL COMMENT '副表ID',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='系统文章模型表';

-- ----------------------------
-- Records of $prefix$article
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$article` VALUES (6, '', 1, 'zh', 0, 1, 1635736625, 1635771952);
INSERT INTO `$prefix$article` VALUES (7, '', 1, 'zh', 0, 2, 1635737755, 1635771936);
INSERT INTO `$prefix$article` VALUES (8, '', 1, 'zh', 0, 3, 1635737900, 1635771911);
INSERT INTO `$prefix$article` VALUES (9, '', 1, 'zh', 0, 4, 1635738046, 1635771884);
INSERT INTO `$prefix$article` VALUES (10, '', 1, 'zh', 0, 5, 1635738144, 1635770316);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$article_test
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$article_test`;
CREATE TABLE `$prefix$article_test` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `sub_title` varchar(255) DEFAULT '' COMMENT '副标题',
  `image` int(11) DEFAULT NULL COMMENT '单图',
  `more_image` varchar(255) DEFAULT '' COMMENT '多图',
  `file` int(11) DEFAULT NULL COMMENT '单视频',
  `more_video` varchar(255) DEFAULT '' COMMENT '多视频',
  `files` int(11) DEFAULT NULL COMMENT '单文件',
  `more_file` varchar(255) DEFAULT '' COMMENT '多文件',
  `seller_id` bigint(20) unsigned DEFAULT NULL COMMENT '商户ID',
  `lang` varchar(255) DEFAULT 'zh' COMMENT '语言标识',
  `lang_pid` int(11) DEFAULT '0' COMMENT '语言锚点',
  `sub_id` bigint(20) unsigned DEFAULT NULL COMMENT '副表ID',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='文章模型表';

-- ----------------------------
-- Records of $prefix$article_test
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$article_test` VALUES (1, '222222', NULL, '', NULL, '', NULL, '', 1, 'zh', 0, 32, 1635735278, 1635735278);
INSERT INTO `$prefix$article_test` VALUES (2, '222222', NULL, '', NULL, '', NULL, '', 1, 'zh', 0, 33, 1635735304, 1635735304);
INSERT INTO `$prefix$article_test` VALUES (3, '2222', NULL, '', NULL, '', NULL, '', 1, 'zh', 0, 34, 1635735954, 1635747532);
INSERT INTO `$prefix$article_test` VALUES (4, '222222', NULL, '', NULL, '', NULL, '', 1, 'zh', 0, 35, 1635760324, 1635760324);
INSERT INTO `$prefix$article_test` VALUES (5, '1111', 67, '', NULL, '', NULL, '', 1, 'zh', 0, 36, 1635931656, 1635931656);
INSERT INTO `$prefix$article_test` VALUES (6, '232333', 67, '', NULL, '', NULL, '', 1, 'zh', 0, 37, 1635932155, 1635932155);
INSERT INTO `$prefix$article_test` VALUES (7, '1111', 62, '', NULL, '', NULL, '', 1, 'zh', 0, 38, 1635932316, 1635932843);
INSERT INTO `$prefix$article_test` VALUES (8, '222', 0, '', NULL, '', 66, '', 1, 'zh', 0, 39, 1635934786, 1635934786);
INSERT INTO `$prefix$article_test` VALUES (9, '1212', 0, '', 0, '', 74, '', 1, 'zh', 0, 40, 1635935395, 1635935395);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$attachment
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$attachment`;
CREATE TABLE `$prefix$attachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '附件id',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `name` varchar(255) DEFAULT '' COMMENT '附件名称',
  `attachment_cate_id` int(11) DEFAULT NULL COMMENT '分类ID',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `url` varchar(255) DEFAULT '' COMMENT '附件访问地址',
  `mime_type` varchar(255) DEFAULT '' COMMENT '文件类型',
  `type` int(2) DEFAULT NULL COMMENT '0 所有 1 压缩包 2 图片 3 视频 4 文件 5 音频',
  `storage` tinyint(2) DEFAULT '1' COMMENT '1 本地 2  阿里 3 腾讯 4 七牛',
  `size` double(10,2) DEFAULT NULL,
  `is_del` int(11) DEFAULT '1' COMMENT '删除 1 正常  2 已删除',
  `delete_time` int(11) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8mb4 COMMENT='附件表';

-- ----------------------------
-- Records of $prefix$attachment
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$attachment` VALUES (3, 1, 'pailiu.png', NULL, NULL, 'storage/image/20211101/38be917083b9679d8e08e9f0b8a8ed78.png', 'image/png', 2, 1, 15.98, 1, NULL, 1635729944, 1635729944);
INSERT INTO `$prefix$attachment` VALUES (4, 1, 'news_info_content_img2.png', NULL, NULL, 'storage/image/20211101/fc5b4d70b3bbf7bd10da18c8678736be.png', 'image/png', 2, 1, 136.02, 2, 1635758944, 1635733706, 1635758944);
INSERT INTO `$prefix$attachment` VALUES (5, 1, 'news_info_content_img1.png', NULL, NULL, 'storage/image/20211101/cf788372068a567c099afcff960fb847.png', 'image/png', 2, 1, 154.88, 2, 1635758946, 1635733730, 1635758946);
INSERT INTO `$prefix$attachment` VALUES (6, 1, 'news_info_content_img3.png', NULL, NULL, 'storage/image/20211101/805e475b1e9c78de80b9e861792542c2.png', 'image/png', 2, 1, 137.87, 2, 1635758948, 1635733767, 1635758948);
INSERT INTO `$prefix$attachment` VALUES (7, 1, 'img1.jpg', NULL, NULL, 'storage/image/20211101/9563a1880c7b7bbc40dbe11fcbaf55ab.jpg', 'image/jpeg', 2, 1, 3.79, 1, NULL, 1635738390, 1635738390);
INSERT INTO `$prefix$attachment` VALUES (8, 1, 'img2.jpg', NULL, NULL, 'storage/image/20211101/8c7ebbbe29124ed2c8dc5f42ba2beb1a.jpg', 'image/jpeg', 2, 1, 4.02, 1, NULL, 1635738419, 1635738419);
INSERT INTO `$prefix$attachment` VALUES (9, 1, 'img3.jpg', NULL, NULL, 'storage/image/20211101/6ab69d312f43fa93184c22f968c8dbf7.jpg', 'image/jpeg', 2, 1, 5.39, 1, NULL, 1635738432, 1635738432);
INSERT INTO `$prefix$attachment` VALUES (10, 1, 'img4.jpg', NULL, NULL, 'storage/image/20211101/a9f496fce1907563ba93c3a401c87fde.jpg', 'image/jpeg', 2, 1, 3.77, 1, NULL, 1635738500, 1635738500);
INSERT INTO `$prefix$attachment` VALUES (11, 1, 'img5.jpg', NULL, NULL, 'storage/image/20211101/85483b6b0b69d20437f299d985927eaa.jpg', 'image/jpeg', 2, 1, 4.04, 1, NULL, 1635738598, 1635738598);
INSERT INTO `$prefix$attachment` VALUES (12, 1, 'img6.jpg', NULL, NULL, 'storage/image/20211101/1736a949eca7ea1ddcfeae2ba136eae0.jpg', 'image/jpeg', 2, 1, 3.83, 1, NULL, 1635738609, 1635738609);
INSERT INTO `$prefix$attachment` VALUES (13, 1, 'brand.png', NULL, NULL, 'storage/image/20211101/070b64627dff6822ebc2ff75f5038d27.png', 'image/png', 2, 1, 229.35, 1, NULL, 1635742889, 1635742889);
INSERT INTO `$prefix$attachment` VALUES (14, 1, 'news_banner.jpg', NULL, NULL, 'storage/image/20211101/6827d474d2af78a61180865fa30f21aa.jpg', 'image/jpeg', 2, 1, 495.63, 1, NULL, 1635743060, 1635743060);
INSERT INTO `$prefix$attachment` VALUES (15, 1, 'news_bin1.jpg', NULL, NULL, 'storage/image/20211101/76dfb6004e2d6456629239a8d438d6b2.jpg', 'image/jpeg', 2, 1, 642.78, 1, NULL, 1635753576, 1635753576);
INSERT INTO `$prefix$attachment` VALUES (16, 1, 'news_bin2.jpg', NULL, NULL, 'storage/image/20211101/fd80087cef6735223ada389c861d5335.jpg', 'image/jpeg', 2, 1, 310.03, 1, NULL, 1635753595, 1635753595);
INSERT INTO `$prefix$attachment` VALUES (17, 1, 'news_bin3.jpg', NULL, NULL, 'storage/image/20211101/fbb92441d3bf85476e3080038933d68a.jpg', 'image/jpeg', 2, 1, 164.24, 1, NULL, 1635753613, 1635753613);
INSERT INTO `$prefix$attachment` VALUES (18, 1, 'news_bin4.jpg', NULL, NULL, 'storage/image/20211101/06f865e23d0457152c2e7e97e9009e75.jpg', 'image/jpeg', 2, 1, 132.76, 1, NULL, 1635753627, 1635753627);
INSERT INTO `$prefix$attachment` VALUES (19, 1, 'news_bin5.jpg', NULL, NULL, 'storage/image/20211101/5797acedfc6bd4b91988ebab80e235d7.jpg', 'image/jpeg', 2, 1, 115.81, 1, NULL, 1635753646, 1635753646);
INSERT INTO `$prefix$attachment` VALUES (20, 1, 'news_info_content_img1.jpg', NULL, NULL, 'storage/image/20211101/5d4c96927de514cec71c984f6b97e083.jpg', 'jpg', 2, 1, 24.06, 1, NULL, 1635758964, 1635758964);
INSERT INTO `$prefix$attachment` VALUES (21, 1, 'news_info_content_img2.jpg', NULL, NULL, 'storage/image/20211101/47f987cf9af227a2d9b18ad8cf6d127d.jpg', 'jpg', 2, 1, 20.59, 1, NULL, 1635758970, 1635758970);
INSERT INTO `$prefix$attachment` VALUES (22, 1, 'news_info_content_img3.jpg', NULL, NULL, 'storage/image/20211101/17003e2dc2243a5c38fe9ae4a8c23735.jpg', 'jpg', 2, 1, 22.99, 1, NULL, 1635758976, 1635758976);
INSERT INTO `$prefix$attachment` VALUES (23, 1, 'product1.png', NULL, NULL, 'storage/image/20211101/d3353c538092e502cd10587342a4b0d5.png', 'png', 2, 1, 23.38, 1, NULL, 1635761632, 1635761632);
INSERT INTO `$prefix$attachment` VALUES (24, 1, 'product2.png', NULL, NULL, 'storage/image/20211101/79f39cc3eb91146c531cde909803bb46.png', 'png', 2, 1, 26.77, 1, NULL, 1635761640, 1635761640);
INSERT INTO `$prefix$attachment` VALUES (25, 1, 'product3.png', NULL, NULL, 'storage/image/20211101/95d76b393024b96a6de787e48b5b98e6.png', 'png', 2, 1, 27.93, 1, NULL, 1635761647, 1635761647);
INSERT INTO `$prefix$attachment` VALUES (26, 1, 'product4.png', NULL, NULL, 'storage/image/20211101/5d517907fe3ce0e8266cac5d037ad11c.png', 'png', 2, 1, 50.63, 1, NULL, 1635761662, 1635761662);
INSERT INTO `$prefix$attachment` VALUES (27, 1, 'product5.png', NULL, NULL, 'storage/image/20211101/f2b9323a1ff901e9f5e533bee53c3c63.png', 'png', 2, 1, 45.69, 1, NULL, 1635761669, 1635761669);
INSERT INTO `$prefix$attachment` VALUES (28, 1, 'product6.png', NULL, NULL, 'storage/image/20211101/e20877b7e303960bbc5918d93c849db1.png', 'png', 2, 1, 43.43, 1, NULL, 1635761679, 1635761679);
INSERT INTO `$prefix$attachment` VALUES (29, 1, 'product_banner1.png', NULL, NULL, 'storage/image/20211101/3d8e28716f77eaa5e2a85ce0cb93fbc5.png', 'png', 2, 1, 287.15, 1, NULL, 1635761695, 1635761695);
INSERT INTO `$prefix$attachment` VALUES (30, 1, 'logo.png', NULL, NULL, 'storage/image/20211101/ff29e6d545ecf34bf129a668e401f003.png', 'png', 2, 1, 1.54, 1, NULL, 1635761707, 1635761707);
INSERT INTO `$prefix$attachment` VALUES (31, 1, 'productInfo_banner.jpg', NULL, NULL, 'storage/image/20211101/20a5f48d8c042741a8ed5a1812c6b392.jpg', 'jpg', 2, 1, 115.57, 1, NULL, 1635761728, 1635761728);
INSERT INTO `$prefix$attachment` VALUES (32, 1, 'productInfo1.jpg', NULL, NULL, 'storage/image/20211101/6475ebedbe99ffa3d4828f28e4945ec1.jpg', 'jpg', 2, 1, 305.89, 1, NULL, 1635761747, 1635761747);
INSERT INTO `$prefix$attachment` VALUES (33, 1, 'productInfo2.jpg', NULL, NULL, 'storage/image/20211101/978528f42b2f604f0333739aae75d84f.jpg', 'jpg', 2, 1, 361.55, 1, NULL, 1635761753, 1635761753);
INSERT INTO `$prefix$attachment` VALUES (34, 1, 'QRcode.png', NULL, NULL, 'storage/image/20211101/6c9f46f521b86c0c7277fbefea9dae40.png', 'png', 2, 1, 5.19, 1, NULL, 1635761763, 1635761763);
INSERT INTO `$prefix$attachment` VALUES (35, 1, 'productInfo1.jpg', NULL, NULL, 'storage/image/20211101/b076303318fa2b4c714b67642363e004.jpg', 'image/jpeg', 2, 1, 305.89, 1, NULL, 1635762210, 1635762210);
INSERT INTO `$prefix$attachment` VALUES (36, 1, 'productInfo2.jpg', NULL, NULL, 'storage/image/20211101/81017b911fa59c08d1930eec90558547.jpg', 'image/jpeg', 2, 1, 361.55, 1, NULL, 1635762219, 1635762219);
INSERT INTO `$prefix$attachment` VALUES (37, 1, 'brand.png', NULL, NULL, 'storage/image/20211101/aab7356088f9812bc368f74dd875aab2.png', 'image/png', 2, 1, 229.35, 1, NULL, 1635764664, 1635764664);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$attachment_cate
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$attachment_cate`;
CREATE TABLE `$prefix$attachment_cate` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '附件分类ID',
  `seller_id` int(11) unsigned DEFAULT '1' COMMENT '商户ID',
  `parent_id` int(11) DEFAULT '0' COMMENT '父栏目ID',
  `path` varchar(255) DEFAULT NULL COMMENT '路径',
  `title` varchar(255) DEFAULT NULL COMMENT '分类名称',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='附件分类表';

-- ----------------------------
-- Records of $prefix$attachment_cate
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$big_field
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$big_field`;
CREATE TABLE `$prefix$big_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `theme_id` int(11) DEFAULT NULL COMMENT '模版ID',
  `theme_file_id` int(11) NOT NULL DEFAULT '0' COMMENT '模板文件ID',
  `content` longtext COMMENT '初始源代码',
  `draft_content` longtext COMMENT '用户修改源代码',
  `more` mediumtext COMMENT '初始配置',
  `draft_more` mediumtext COMMENT '用户配置',
  `create_time` int(11) NOT NULL DEFAULT '0',
  `update_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COMMENT='模板文件表大内容字段';

-- ----------------------------
-- Records of $prefix$big_field
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$category
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$category`;
CREATE TABLE `$prefix$category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `parent_id` int(11) DEFAULT '0' COMMENT '父分类ID',
  `parent_map` int(11) DEFAULT '0' COMMENT '附站点栏目ID映射',
  `parent_path` varchar(255) DEFAULT NULL COMMENT '附站点栏目ID映射',
  `has_map` tinyint(2) DEFAULT '2' COMMENT '是否映射父栏目 1 是 2 否',
  `website_id` int(11) DEFAULT NULL COMMENT '网站ID',
  `module_id` int(11) DEFAULT NULL COMMENT '模型ID',
  `lang` varchar(255) DEFAULT 'zh' COMMENT '语言 ',
  `lang_pid` int(11) DEFAULT '0' COMMENT '多语言锚点 0 默认语言',
  `type` tinyint(1) DEFAULT '1' COMMENT '栏目类型 1 列表栏目  2 频道封面 3 跳转链接 4 单页面',
  `title` varchar(255) DEFAULT '' COMMENT '分类名称',
  `sub_title` varchar(255) DEFAULT '' COMMENT '分类名称',
  `content` text COMMENT '内容',
  `path` varchar(255) DEFAULT '' COMMENT '分类路径(到最上一层父级路径)',
  `desc` varchar(255) DEFAULT '' COMMENT '分类简介',
  `description` varchar(255) DEFAULT '' COMMENT '分类描述',
  `sort` int(11) DEFAULT '100' COMMENT '分类排序',
  `alias` varchar(255) DEFAULT '' COMMENT '栏目别名',
  `banner` int(11) DEFAULT NULL COMMENT 'banner图',
  `thumbnail` int(11) DEFAULT NULL COMMENT '缩略图',
  `list_tpl` varchar(255) DEFAULT '' COMMENT '分类列表模板',
  `detail_tpl` varchar(255) DEFAULT '' COMMENT '详情页模版',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 正常 2 禁用',
  `is_search` tinyint(2) DEFAULT '2' COMMENT '栏目是否搜索',
  `seo_title` varchar(100) NOT NULL DEFAULT '',
  `seo_keywords` varchar(255) NOT NULL DEFAULT '',
  `seo_description` varchar(255) NOT NULL DEFAULT '',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COMMENT='栏目表';

-- ----------------------------
-- Records of $prefix$category
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$category` VALUES (1, 1, 0, 0, NULL, 2, 1, NULL, 'zh', 0, 4, '首页', '', NULL, '0-', '', '', 100, '/', NULL, NULL, 'index', '', 1, 2, '网站首页', '网站首页', '网站首页', 1635478353, 1641526807);
INSERT INTO `$prefix$category` VALUES (5, 1, 0, 0, NULL, 2, 1, 1, 'zh', 0, 1, '新闻资讯', '', NULL, '0-', '', '我们的产品遍布全国31个省、630多座城市', 110, '/new', 14, 13, 'list_news', 'detail_news_info', 1, 2, '', '', '', 1635731380, 1641526807);
INSERT INTO `$prefix$category` VALUES (6, 1, 0, 0, NULL, 2, 1, 2, 'zh', 0, 4, '客户', '', NULL, '0-', '', '', 120, '/customer', NULL, NULL, 'list_news', '', 1, 2, '', '', '', 1635738289, 1641526807);
INSERT INTO `$prefix$category` VALUES (7, 1, 0, 0, NULL, 2, 1, 1, 'zh', 0, 4, '品牌介绍', '', NULL, '0-', '', '得事家电品牌正式进入中国，基于对中国市场的深刻洞察和准确定位，得事家电品牌在中国完成了全产业链布局，严格而先进的全球统一标准，贯穿了研发、采购、生产、销售直至售后服务全部家电产业生态系统的所有环节，为该品牌提供支持的投资公司、产品研发中心、原材料采购中心、销售公司、服务公司等机构遍布全国各地。', 130, '/introduction', 0, 37, 'news', '', 1, 2, '', '', '', 1635738972, 1641526807);
INSERT INTO `$prefix$category` VALUES (9, 1, 5, 0, NULL, 2, 1, 1, 'zh', 0, 1, '公司新闻', '', NULL, '0-5-', '', '', 100, '/company_new', 14, 0, 'list_news', 'detail_news_info', 1, 2, '', '', '', 1635748867, 1641526807);
INSERT INTO `$prefix$category` VALUES (10, 1, 5, 0, NULL, 2, 1, 1, 'zh', 0, 1, '行业资讯', '', NULL, '0-5-', '', '', 110, '/industry_new', 14, 0, 'list_news', 'detail_news_info', 1, 2, '', '', '', 1635748895, 1641526807);
INSERT INTO `$prefix$category` VALUES (11, 1, 0, 0, NULL, 2, 1, 3, 'zh', 0, 1, '产品', '', NULL, '0-', '', '得事家电品牌正式进入中国，基于对中国市场的深刻洞察和准确定位，得事家电品牌在中国完成了全产业链布局，严格而先进的全球统一标准，贯穿了研发、采购、生产、销售直至售后服务全部家电产业生态系统的所有环节，为该品牌提供支持的投资公司、产品研发中心、原材料采购中心、销售公司、服务公司等机构遍布全国各地。', 140, '/product', 37, 0, 'list_product', 'detail_product_info', 1, 2, '', '', '', 1635761247, 1641526807);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$category_sub_content
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$category_sub_content`;
CREATE TABLE `$prefix$category_sub_content` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `seller_id` int(11) DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT NULL COMMENT '网站ID',
  `category_id` int(11) DEFAULT NULL COMMENT '分类ID',
  `sub_content_id` int(10) unsigned DEFAULT NULL COMMENT '内容副表ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COMMENT='分类内容关联表';

-- ----------------------------
-- Records of $prefix$category_sub_content
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$category_sub_content` VALUES (6, 1, NULL, 6, 6);
INSERT INTO `$prefix$category_sub_content` VALUES (7, 1, NULL, 6, 7);
INSERT INTO `$prefix$category_sub_content` VALUES (8, 1, NULL, 6, 8);
INSERT INTO `$prefix$category_sub_content` VALUES (9, 1, NULL, 6, 9);
INSERT INTO `$prefix$category_sub_content` VALUES (10, 1, NULL, 6, 10);
INSERT INTO `$prefix$category_sub_content` VALUES (11, 1, NULL, 6, 11);
INSERT INTO `$prefix$category_sub_content` VALUES (12, 1, NULL, 6, 12);
INSERT INTO `$prefix$category_sub_content` VALUES (13, 1, NULL, 6, 13);
INSERT INTO `$prefix$category_sub_content` VALUES (50, 1, NULL, 11, 14);
INSERT INTO `$prefix$category_sub_content` VALUES (52, 1, NULL, 11, 16);
INSERT INTO `$prefix$category_sub_content` VALUES (59, 1, NULL, 11, 21);
INSERT INTO `$prefix$category_sub_content` VALUES (60, 1, NULL, 11, 20);
INSERT INTO `$prefix$category_sub_content` VALUES (61, 1, NULL, 11, 19);
INSERT INTO `$prefix$category_sub_content` VALUES (62, 1, NULL, 11, 18);
INSERT INTO `$prefix$category_sub_content` VALUES (63, 1, NULL, 11, 17);
INSERT INTO `$prefix$category_sub_content` VALUES (65, 1, NULL, 11, 15);
INSERT INTO `$prefix$category_sub_content` VALUES (66, 1, NULL, 9, 5);
INSERT INTO `$prefix$category_sub_content` VALUES (67, 1, NULL, 10, 5);
INSERT INTO `$prefix$category_sub_content` VALUES (68, 1, NULL, 9, 4);
INSERT INTO `$prefix$category_sub_content` VALUES (69, 1, NULL, 10, 4);
INSERT INTO `$prefix$category_sub_content` VALUES (70, 1, NULL, 9, 3);
INSERT INTO `$prefix$category_sub_content` VALUES (71, 1, NULL, 10, 3);
INSERT INTO `$prefix$category_sub_content` VALUES (72, 1, NULL, 9, 2);
INSERT INTO `$prefix$category_sub_content` VALUES (73, 1, NULL, 10, 2);
INSERT INTO `$prefix$category_sub_content` VALUES (74, 1, NULL, 9, 1);
INSERT INTO `$prefix$category_sub_content` VALUES (75, 1, NULL, 10, 1);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$customer
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$customer`;
CREATE TABLE `$prefix$customer` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `seller_id` bigint(20) unsigned DEFAULT NULL COMMENT '商户ID',
  `lang` varchar(255) DEFAULT 'zh' COMMENT '语言标识',
  `lang_pid` int(11) DEFAULT '0' COMMENT '语言锚点',
  `sub_id` bigint(20) unsigned DEFAULT NULL COMMENT '副表ID',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COMMENT='客户模型表';

-- ----------------------------
-- Records of $prefix$customer
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$customer` VALUES (1, 1, 'zh', 0, 6, 1635738391, 1635738391);
INSERT INTO `$prefix$customer` VALUES (2, 1, 'zh', 0, 7, 1635738420, 1635738420);
INSERT INTO `$prefix$customer` VALUES (3, 1, 'zh', 0, 8, 1635738433, 1635738433);
INSERT INTO `$prefix$customer` VALUES (4, 1, 'zh', 0, 9, 1635738501, 1635738501);
INSERT INTO `$prefix$customer` VALUES (5, 1, 'zh', 0, 10, 1635738599, 1635738599);
INSERT INTO `$prefix$customer` VALUES (6, 1, 'zh', 0, 11, 1635738610, 1635738610);
INSERT INTO `$prefix$customer` VALUES (7, 1, 'zh', 0, 12, 1635748035, 1635748035);
INSERT INTO `$prefix$customer` VALUES (8, 1, 'zh', 0, 13, 1635748056, 1635748056);
INSERT INTO `$prefix$customer` VALUES (9, 1, 'zh', 0, 22, 1635779954, 1635779954);
INSERT INTO `$prefix$customer` VALUES (10, 1, 'zh', 0, 23, 1635779986, 1635779986);
INSERT INTO `$prefix$customer` VALUES (11, 1, 'zh', 0, 24, 1635779998, 1635779998);
INSERT INTO `$prefix$customer` VALUES (12, 1, 'zh', 0, 25, 1635780009, 1635780009);
INSERT INTO `$prefix$customer` VALUES (13, 1, 'zh', 0, 26, 1635780027, 1635780027);
INSERT INTO `$prefix$customer` VALUES (14, 1, 'zh', 0, 27, 1635780044, 1635780044);
INSERT INTO `$prefix$customer` VALUES (15, 1, 'zh', 0, 28, 1635780064, 1635780064);
INSERT INTO `$prefix$customer` VALUES (16, 1, 'zh', 0, 29, 1635780080, 1635780080);
INSERT INTO `$prefix$customer` VALUES (17, 1, 'zh', 0, 30, 1635780102, 1635780102);
INSERT INTO `$prefix$customer` VALUES (18, 1, 'zh', 0, 31, 1635780119, 1635780119);
INSERT INTO `$prefix$customer` VALUES (19, 1, 'zh', 0, 32, 1635780152, 1635780152);
INSERT INTO `$prefix$customer` VALUES (20, 1, 'zh', 0, 33, 1635780204, 1635780204);
INSERT INTO `$prefix$customer` VALUES (21, 1, 'zh', 0, 34, 1635780217, 1635780217);
INSERT INTO `$prefix$customer` VALUES (22, 1, 'zh', 0, 35, 1635780229, 1635780229);
INSERT INTO `$prefix$customer` VALUES (23, 1, 'zh', 0, 36, 1635780239, 1635780239);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$database
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$database`;
CREATE TABLE `$prefix$database` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seller_id` int(11) NOT NULL DEFAULT '0' COMMENT '商户ID',
  `title` varchar(255) DEFAULT '' COMMENT '文件名称',
  `size` double(11,2) DEFAULT NULL COMMENT '文件大小',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='数据库备份表';

-- ----------------------------
-- Records of $prefix$database
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$demo_product
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$demo_product`;
CREATE TABLE `$prefix$demo_product` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `intro_img` varchar(255) DEFAULT '' COMMENT '产品图集',
  `design_style` varchar(255) DEFAULT '' COMMENT '设计风格',
  `seller_id` bigint(20) unsigned DEFAULT NULL COMMENT '商户ID',
  `lang` varchar(255) DEFAULT 'zh' COMMENT '语言标识',
  `lang_pid` int(11) DEFAULT '0' COMMENT '语言锚点',
  `sub_id` bigint(20) unsigned DEFAULT NULL COMMENT '副表ID',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='demo产品模型表';

-- ----------------------------
-- Records of $prefix$demo_product
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$demo_product` VALUES (2, '[\"35\",\"36\"]', '曼海姆SAP竞技场是运动竞技场演化的终极例子。', 1, 'zh', 0, 15, 1635762223, 1635765649);
INSERT INTO `$prefix$demo_product` VALUES (3, '[\"35\",\"36\"]', '家能够完美彰显房子主人的风格特点。在家里，一切风格和功能都按照你的喜好和需求设计', 1, 'zh', 0, 16, 1635762272, 1635762866);
INSERT INTO `$prefix$demo_product` VALUES (4, '[\"35\",\"36\"]', '家能够完美彰显房子主人的风格特点。在家里，一切风格和功能都按照你的喜好和需求设计', 1, 'zh', 0, 17, 1635762327, 1635765612);
INSERT INTO `$prefix$demo_product` VALUES (5, '[\"35\",\"36\"]', '设计优秀', 1, 'zh', 0, 18, 1635762347, 1635765601);
INSERT INTO `$prefix$demo_product` VALUES (6, '[\"35\",\"36\"]', '设计优秀', 1, 'zh', 0, 19, 1635762367, 1635765571);
INSERT INTO `$prefix$demo_product` VALUES (7, '[\"35\",\"36\"]', '设计优秀', 1, 'zh', 0, 20, 1635762385, 1635765556);
INSERT INTO `$prefix$demo_product` VALUES (8, '[\"35\",\"36\"]', '设计优秀', 1, 'zh', 0, 21, 1635762415, 1635765544);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$inner_chart
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$inner_chart`;
CREATE TABLE `$prefix$inner_chart` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '外链ID',
  `seller_id` int(11) DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT NULL COMMENT '站点ID',
  `type` tinyint(2) DEFAULT '1' COMMENT '内链类型 1 站点标签 2 通用标签',
  `count` tinyint(3) DEFAULT NULL COMMENT '内链类型 1 站点标签 2 通用标签',
  `keyword` varchar(255) DEFAULT NULL COMMENT '关键词',
  `url` varchar(255) DEFAULT NULL COMMENT '内链',
  `weight` int(11) DEFAULT '10' COMMENT '权重 权重越高替换优先级越高',
  `new_page_open` tinyint(2) DEFAULT '1' COMMENT '新窗口打开 1 是 2 否',
  `status` int(11) DEFAULT '1' COMMENT '启用 1 是 2 否',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='内链表';

-- ----------------------------
-- Records of $prefix$inner_chart
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$inner_chart_sub_content
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$inner_chart_sub_content`;
CREATE TABLE `$prefix$inner_chart_sub_content` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类id',
  `seller_id` int(10) unsigned DEFAULT NULL COMMENT '商户ID',
  `inner_chart_id` int(10) unsigned DEFAULT NULL COMMENT '内链 id',
  `sub_content_id` int(10) unsigned DEFAULT NULL COMMENT '内容 id',
  `total` tinyint(3) DEFAULT NULL COMMENT '内容内链数量',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章内链关联表';

-- ----------------------------
-- Records of $prefix$inner_chart_sub_content
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$inquiry
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$inquiry`;
CREATE TABLE `$prefix$inquiry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seller_id` int(11) DEFAULT '1' COMMENT '所属商户的id',
  `website_id` int(11) DEFAULT NULL COMMENT '网站ID',
  `company_name` varchar(255) DEFAULT NULL COMMENT '客户名称',
  `contacts_name` varchar(55) DEFAULT NULL COMMENT '联系人姓名',
  `content` varchar(255) DEFAULT NULL COMMENT '询盘内容',
  `telphone` varchar(50) DEFAULT NULL COMMENT '固定电话',
  `phone` varchar(11) DEFAULT NULL COMMENT '联系人手机号',
  `wechat` varchar(120) DEFAULT NULL COMMENT '微信号',
  `email` varchar(80) DEFAULT NULL COMMENT '邮箱',
  `qq` varchar(255) DEFAULT NULL COMMENT 'QQ',
  `inquiry_type` varchar(255) DEFAULT NULL COMMENT '询盘类型',
  `company_address` varchar(200) DEFAULT NULL COMMENT '公司地址',
  `company_site` varchar(155) DEFAULT NULL COMMENT '企业网址',
  `referer` varchar(50) DEFAULT NULL COMMENT '询盘来源',
  `referer_web` varchar(200) DEFAULT NULL COMMENT '来源网址',
  `ip` varchar(20) DEFAULT NULL COMMENT 'ip',
  `expect_amount` decimal(13,2) DEFAULT NULL COMMENT '预算金额',
  `explain` text COMMENT '需求说明',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态1默认2转线索',
  `is_del` tinyint(2) DEFAULT '1' COMMENT '1默认2删除',
  `delete_time` int(11) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商户询盘表';

-- ----------------------------
-- Records of $prefix$inquiry
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$inquiry_category
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$inquiry_category`;
CREATE TABLE `$prefix$inquiry_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '询盘分类表',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `name` varchar(120) DEFAULT '' COMMENT '分类名称',
  `create_time` int(11) DEFAULT '0',
  `update_time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='询盘分类表';

-- ----------------------------
-- Records of $prefix$inquiry_category
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$inquiry_category` VALUES (1, 1, '普通询盘', 1635251132, 1635251132);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$inquiry_email
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$inquiry_email`;
CREATE TABLE `$prefix$inquiry_email` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '邮箱ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱地址',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态 1 正常 2 禁用',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='邮箱设置表';

-- ----------------------------
-- Records of $prefix$inquiry_email
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$job
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$job`;
CREATE TABLE `$prefix$job` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '职位ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT '0' COMMENT '网站ID 默认值 0 表示属于所有站点',
  `job_cate_id` int(11) DEFAULT NULL COMMENT '职位分类ID',
  `job_city_id` int(11) DEFAULT NULL COMMENT '职位城市',
  `title` varchar(255) DEFAULT NULL COMMENT '职位名称',
  `description` varchar(255) DEFAULT NULL COMMENT '职位描述',
  `duty` varchar(255) DEFAULT NULL COMMENT '职责',
  `demand` varchar(255) DEFAULT NULL COMMENT '任职要求',
  `salary` varchar(255) DEFAULT NULL COMMENT '薪水',
  `schedule` varchar(255) DEFAULT NULL COMMENT '招聘日期',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态 1 进行中 2 截止',
  `email` varchar(255) DEFAULT '1' COMMENT '邮件发送地址',
  `is_del` varchar(255) DEFAULT '1',
  `delete_time` int(11) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='招聘岗位表';

-- ----------------------------
-- Records of $prefix$job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$job_cate
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$job_cate`;
CREATE TABLE `$prefix$job_cate` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '职位分类ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `title` varchar(255) DEFAULT NULL COMMENT '分类名称',
  `is_del` tinyint(4) DEFAULT '1',
  `delete_time` int(11) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='岗位分类表';

-- ----------------------------
-- Records of $prefix$job_cate
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$job_cate` VALUES (1, 1, '日常招聘', 1, NULL, 1635406156, 1635406156);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$job_city
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$job_city`;
CREATE TABLE `$prefix$job_city` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '城市ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT ' 商户id',
  `title` varchar(255) DEFAULT '' COMMENT '城市名称',
  `is_del` tinyint(1) DEFAULT '1' COMMENT '删除 1 正常 2 删除',
  `delete_time` int(11) unsigned DEFAULT NULL,
  `create_time` int(11) unsigned DEFAULT NULL,
  `update_time` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='招聘城市表';

-- ----------------------------
-- Records of $prefix$job_city
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$job_city` VALUES (1, 1, '上海', 1, NULL, 1635406156, 1635406156);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$keyword
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$keyword`;
CREATE TABLE `$prefix$keyword` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '关键词ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT NULL COMMENT '站点ID',
  `type` varchar(255) DEFAULT '' COMMENT '关键词类型',
  `name` varchar(120) DEFAULT '' COMMENT '关键词明名称',
  `url` varchar(255) DEFAULT '' COMMENT '域名地址',
  `position` varchar(255) DEFAULT NULL COMMENT '关键词分布位置',
  `baidu_pc` int(11) DEFAULT NULL COMMENT '百度PC',
  `baidu_mob` int(11) DEFAULT NULL COMMENT '百度移动端',
  `three_pc` int(11) DEFAULT NULL COMMENT '360PC',
  `sougou_mob` int(11) DEFAULT NULL COMMENT '搜狗MOB',
  `baidu_index` int(11) DEFAULT NULL COMMENT '百度指数',
  `baidu_mob_index` int(11) DEFAULT NULL COMMENT '百度移动指数',
  `three_index` int(11) DEFAULT NULL COMMENT '360指数',
  `bidding_intensity` int(11) DEFAULT NULL COMMENT '竞价激烈程度',
  `baidu_search` int(11) DEFAULT NULL COMMENT '百度PC检索量',
  `baidu_mob_search` int(11) DEFAULT NULL COMMENT '百度移动检索量',
  `baidu_included` int(11) DEFAULT NULL COMMENT '百度收录量',
  `long_tail_word` int(11) DEFAULT NULL COMMENT '长尾词个数',
  `sem_price` decimal(10,0) DEFAULT NULL COMMENT 'sem点击价格',
  `bidding_company` int(11) DEFAULT NULL COMMENT '竞价公司数量',
  `status` tinyint(2) DEFAULT NULL COMMENT '状态 1 正常 2 暂停 ',
  `sort` int(11) DEFAULT '1000' COMMENT '排序',
  `is_del` tinyint(4) DEFAULT '1' COMMENT '删除 1 正常 2 删除',
  `delete_time` int(11) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='关键词表';

-- ----------------------------
-- Records of $prefix$keyword
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$keyword_query
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$keyword_query`;
CREATE TABLE `$prefix$keyword_query` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '关键词ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT NULL COMMENT '站点ID',
  `keyword` varchar(120) DEFAULT '' COMMENT '关键词名称',
  `search_engine` varchar(255) DEFAULT NULL COMMENT '搜索引擎',
  `collect_count` int(11) DEFAULT NULL COMMENT '关键词收录量',
  `ip` varchar(255) DEFAULT NULL COMMENT '采集IP',
  `area` varchar(255) DEFAULT NULL COMMENT '采集区域',
  `network` varchar(255) DEFAULT NULL COMMENT '采集网络',
  `top_rank` tinyint(3) DEFAULT NULL COMMENT '最高排名',
  `ranks` text COMMENT '排名数据',
  `page_title` varchar(255) DEFAULT NULL COMMENT '页面标题',
  `page_url` varchar(255) DEFAULT NULL COMMENT '页面链接地址',
  `top100` int(11) DEFAULT NULL COMMENT '网站域名在5118中的Top100关键词排名数量',
  `site_weight` varchar(255) DEFAULT NULL COMMENT '网站权重',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='关键词表';

-- ----------------------------
-- Records of $prefix$keyword_query
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$keyword_website
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$keyword_website`;
CREATE TABLE `$prefix$keyword_website` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `keyword_id` int(11) DEFAULT '0' COMMENT '关键词ID',
  `website_id` int(11) DEFAULT '0' COMMENT '网站ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='关键词网站关联表';

-- ----------------------------
-- Records of $prefix$keyword_website
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$link
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$link`;
CREATE TABLE `$prefix$link` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '友情链接ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(10) unsigned DEFAULT NULL COMMENT '网站ID',
  `name` varchar(120) DEFAULT '' COMMENT '友情链接名称',
  `url` varchar(150) DEFAULT '' COMMENT '友情链接地址',
  `type` tinyint(1) DEFAULT NULL COMMENT '链接类型 1 导入链接 2 导出链接',
  `url_type` tinyint(1) DEFAULT NULL COMMENT '链接类型 1 友情交换 2 链接出售 3 链接购买 4 版权链接',
  `site_type` tinyint(2) DEFAULT NULL COMMENT '网站类型 1 企业站 2 新闻站 3 博客站 4 论坛站 5 门户站',
  `sort` smallint(5) unsigned DEFAULT '10' COMMENT '排序',
  `baidu_weight` int(11) DEFAULT NULL COMMENT '百度权重',
  `position` varchar(255) DEFAULT NULL COMMENT '链接位置',
  `export_link` int(11) DEFAULT NULL COMMENT '导出链接',
  `check_log` tinyint(2) DEFAULT NULL COMMENT '检查记录 1 存在 2 不存在',
  `add_person` varchar(255) DEFAULT NULL COMMENT '添加人',
  `pr_value` int(11) DEFAULT NULL COMMENT 'PR值',
  `contact_person` varchar(255) DEFAULT NULL COMMENT '联系人',
  `mobile` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `add_time` date DEFAULT NULL COMMENT '添加时间',
  `end_time` date DEFAULT NULL COMMENT '截止日期',
  `duration` varchar(255) DEFAULT NULL COMMENT '时长',
  `price` varchar(255) DEFAULT NULL COMMENT '价格',
  `exchange_platform` varchar(255) DEFAULT NULL COMMENT '交换平台',
  `target` int(11) NOT NULL DEFAULT '2' COMMENT '链接打开方式 1 本页打开 2 新标签打开',
  `is_del` tinyint(4) NOT NULL DEFAULT '1' COMMENT '删除 1 正常',
  `delete_time` int(11) NOT NULL DEFAULT '0',
  `create_time` int(11) NOT NULL DEFAULT '0',
  `update_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='友情链接表';

-- ----------------------------
-- Records of $prefix$link
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$link` VALUES (1, 1, 1, '智火营销', 'http://zhco.com', 1, 1, 1, 1, NULL, '', 0, 1, 'reid', 0, '', '', NULL, NULL, NULL, NULL, '', 2, 1, 0, 1635476083, 1635476083);
INSERT INTO `$prefix$link` VALUES (2, 1, 1, '导入链接', 'http://yocm.com', 2, 4, 1, 2, NULL, '', 0, 1, 'reid', 0, '', '', NULL, NULL, NULL, NULL, '', 2, 1, 0, 1635476308, 1635476308);
INSERT INTO `$prefix$link` VALUES (3, 1, 1, '导出链接2', 'http://pailiu.com', 2, 4, 1, 1, NULL, '', 0, 1, 'reid', 0, '', '', NULL, NULL, NULL, NULL, '', 2, 1, 0, 1635476377, 1635476377);
INSERT INTO `$prefix$link` VALUES (4, 1, 2, '智火', 'http://zhco.com', 2, 1, 1, 1, NULL, '', 0, 1, 'reid', 0, '', '', NULL, NULL, NULL, NULL, '', 2, 1, 0, 1635782409, 1635782409);
INSERT INTO `$prefix$link` VALUES (5, 1, 2, '派流', 'http://pailiu.com', 2, 1, 1, 2, NULL, '', 0, 1, 'reid', 0, '', '', NULL, NULL, NULL, NULL, '', 2, 1, 0, 1635782438, 1635782438);
INSERT INTO `$prefix$link` VALUES (6, 1, 2, '智火传媒', 'http://chuanmeibu.com', 2, 1, 1, 3, NULL, '', 0, 1, 'reid', 0, '', '', NULL, NULL, NULL, NULL, '', 2, 1, 0, 1635782510, 1635782510);
INSERT INTO `$prefix$link` VALUES (7, 1, 2, '言鸥', 'http://yocm.com', 2, 1, 1, 4, NULL, '', 0, 1, 'reid', 0, '', '', NULL, NULL, NULL, NULL, '', 2, 1, 0, 1635782549, 1635782549);
INSERT INTO `$prefix$link` VALUES (8, 1, 2, '数旗', 'http://suq.com', 2, 1, 1, 5, NULL, '', 0, 1, 'reid', 0, '', '', NULL, NULL, NULL, NULL, '', 2, 1, 0, 1635782602, 1635782602);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$member
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$member`;
CREATE TABLE `$prefix$member` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '会员ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT '会员名称',
  `email` varchar(60) NOT NULL DEFAULT '' COMMENT '会邮箱',
  `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '会员手机号',
  `password` varchar(120) NOT NULL DEFAULT '' COMMENT '密码',
  `website_id` int(11) NOT NULL DEFAULT '0' COMMENT '网站ID',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态 1 正常 2 禁用',
  `is_del` tinyint(4) NOT NULL DEFAULT '1' COMMENT '删除 1 正常 2 已删除',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT ' ',
  `update_time` int(11) NOT NULL DEFAULT '0',
  `delete_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会员表';

-- ----------------------------
-- Records of $prefix$member
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$member_log
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$member_log`;
CREATE TABLE `$prefix$member_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '登录日志ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `member_id` int(11) NOT NULL DEFAULT '0' COMMENT '站点商户ID',
  `member_name` varchar(120) NOT NULL DEFAULT '' COMMENT '用户名称',
  `ip` varchar(120) NOT NULL DEFAULT '' COMMENT '登录IP',
  `agent` varchar(120) NOT NULL DEFAULT '' COMMENT '登录客户端',
  `login_time` int(11) NOT NULL DEFAULT '0' COMMENT '登录时间',
  `lgout_time` int(11) NOT NULL DEFAULT '0' COMMENT '登出时间',
  `create_time` int(11) NOT NULL DEFAULT '0',
  `update_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户登录日志';

-- ----------------------------
-- Records of $prefix$member_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$module
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$module`;
CREATE TABLE `$prefix$module` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `title` varchar(80) DEFAULT '' COMMENT '模型名称',
  `table` varchar(80) DEFAULT '' COMMENT '用户输入表名',
  `database_table` varchar(120) DEFAULT '' COMMENT '数据库模型对应附表',
  `description` varchar(255) DEFAULT '' COMMENT '描述',
  `type` tinyint(1) DEFAULT '2' COMMENT '模型类型 1 独立模型 2 主表附表模型',
  `is_system` tinyint(1) DEFAULT '2' COMMENT '是否系统模型 1 是 2 不是',
  `status` tinyint(1) DEFAULT '1' COMMENT '1 正常 2 禁用',
  `create_time` int(11) DEFAULT '0',
  `update_time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='模型表';

-- ----------------------------
-- Records of $prefix$module
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$module` VALUES (1, 1, '系统文章模型', 'article', 'hc_article', '系统自带的文章模型', 2, 2, 1, 1635478012, 1635478012);
INSERT INTO `$prefix$module` VALUES (2, 1, '客户模型', 'customer', 'hc_customer', '客户模型', 2, 2, 1, 1635738234, 1635738234);
INSERT INTO `$prefix$module` VALUES (3, 1, 'demo产品模型', 'demo_product', 'hc_demo_product', '演示站点一的产品模型', 2, 2, 1, 1635760192, 1635760192);
INSERT INTO `$prefix$module` VALUES (4, 1, 'demo1案例模型', 'demo_case', 'hc_demo_case', 'demo1案例模型', 2, 2, 1, 1635775531, 1635775531);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$module_field
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$module_field`;
CREATE TABLE `$prefix$module_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `form_title` varchar(80) DEFAULT '' COMMENT '表单标题',
  `table_field` varchar(80) DEFAULT '' COMMENT '数据表字段',
  `module_id` int(11) DEFAULT '0' COMMENT '模型ID',
  `order` varchar(60) DEFAULT '' COMMENT '数据表排序字段',
  `validate_rule` varchar(120) DEFAULT '' COMMENT '验证规格',
  `form_validate` varchar(255) DEFAULT '' COMMENT '表单验证规则',
  `type` varchar(80) DEFAULT '' COMMENT '字段类型',
  `db_type` varchar(80) DEFAULT '' COMMENT '字段类型',
  `form_type` varchar(80) DEFAULT '' COMMENT '表单类型',
  `attach_data` varchar(255) DEFAULT '' COMMENT '列表数据源',
  `settings` varchar(255) DEFAULT '' COMMENT '其他配置',
  `length` varchar(40) DEFAULT '' COMMENT '字段长度',
  `default` varchar(255) DEFAULT '' COMMENT '默认值',
  `placeholder` varchar(255) DEFAULT '' COMMENT '表单提示信息',
  `status` tinyint(4) DEFAULT '1' COMMENT '字段状态 1 正常 2 隐藏',
  `is_null` tinyint(4) DEFAULT '1' COMMENT '字段是否允许为空 1 允许 其他 不允许',
  `create_time` int(11) DEFAULT '0',
  `update_time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COMMENT='模型字段表';

-- ----------------------------
-- Records of $prefix$module_field
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$module_field` VALUES (1, 1, '文章副标题', 'sub_title', 1, 'id', '', '', '单行文本', 'string', 'input', '', '', '', '', '', 1, 1, 1635478171, 1635478171);
INSERT INTO `$prefix$module_field` VALUES (2, 1, '产品图集', 'intro_img', 3, 'id', '', '', '多图', 'string', 'multiImage', '', '', '', '', '', 1, 1, 1635760350, 1635760350);
INSERT INTO `$prefix$module_field` VALUES (3, 1, '设计风格', 'design_style', 3, 'intro_img', '', '', '单行文本', 'string', 'input', '', '', '', '', '', 1, 1, 1635760379, 1635760379);
INSERT INTO `$prefix$module_field` VALUES (4, 1, '字符串标签', 'tag_str', 4, 'case_time', '', '', '单行文本', 'string', 'input', '', '', '', '', '', 1, 1, 1635780423, 1635780423);
INSERT INTO `$prefix$module_field` VALUES (5, 1, '色彩范围', 'color_desc', 4, 'tag_str', '', '', '单行文本', 'string', 'input', '', '', '', '', '', 1, 1, 1635780468, 1635780468);
INSERT INTO `$prefix$module_field` VALUES (6, 1, '色彩左图', 'color_left', 4, 'color_desc', '', '', '图片', 'integer', 'image', '', '', '', '', '', 1, 1, 1635780503, 1635780503);
INSERT INTO `$prefix$module_field` VALUES (7, 1, '色彩右图', 'color_right', 4, 'color_left', '', '', '图片', 'integer', 'image', '', '', '', '', '', 1, 1, 1635780537, 1635780537);
INSERT INTO `$prefix$module_field` VALUES (8, 1, '设计理念', 'design_concept', 4, 'color_right', '', '', '单行文本', 'string', 'input', '', '', '', '', '', 1, 1, 1635780603, 1635780603);
INSERT INTO `$prefix$module_field` VALUES (9, 1, '理念介绍', 'design_desc', 4, 'design_concept', '', '', '多行文本', 'string', 'textarea', '', '', '', '', '', 1, 1, 1635780631, 1635780631);
INSERT INTO `$prefix$module_field` VALUES (10, 1, '详情左图', 'detail_left', 4, 'design_desc', '', '', '多图', 'string', 'multiImage', '', '', '', '', '', 1, 1, 1635780666, 1635780666);
INSERT INTO `$prefix$module_field` VALUES (11, 1, '详情右图', 'detail_right', 4, 'detail_left', '', '', '图片', 'integer', 'image', '', '', '', '', '', 1, 1, 1635780696, 1635780696);
INSERT INTO `$prefix$module_field` VALUES (12, 1, '时间', 'case_time', 4, 'top_thumb', '', '', '日期', 'string', 'date', '', '', '', '', '', 1, 1, 1635780719, 1635780719);
INSERT INTO `$prefix$module_field` VALUES (13, 1, '置顶封面', 'top_thumb', 4, 'id', '', '', '图片', 'integer', 'image', '', '', '', '', '', 1, 1, 1635781651, 1635781651);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$nav
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$nav`;
CREATE TABLE `$prefix$nav` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '导航ID',
  `seller_id` int(11) DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT '0' COMMENT '网站ID',
  `lang` varchar(255) DEFAULT 'zh',
  `parent_id` int(11) DEFAULT '0' COMMENT '父级导航ID',
  `title` varchar(60) DEFAULT '' COMMENT '导航名称',
  `type` tinyint(1) DEFAULT '2' COMMENT '导航类型 1 普通 2 关联栏目',
  `href` varchar(120) DEFAULT NULL COMMENT '导航地址',
  `category_id` int(11) DEFAULT '0' COMMENT '栏目分类ID',
  `nav_cate_id` int(11) DEFAULT '0' COMMENT '导航分类ID',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `target` varchar(255) DEFAULT NULL COMMENT '导航打开方式',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态 1 正常 2 禁用',
  `seo_title` varchar(120) DEFAULT '' COMMENT 'seo标题',
  `seo_keyword` varchar(120) DEFAULT '' COMMENT 'seo关键词',
  `seo_descrition` varchar(255) DEFAULT '' COMMENT 'seo描述',
  `create_time` int(11) DEFAULT '0',
  `update_time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COMMENT='网站导航表';

-- ----------------------------
-- Records of $prefix$nav
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$nav` VALUES (1, 1, 1, 'zh', 0, '首页', 2, '/', 1, 1, 1, '_self', 1, '', '', '', 1635748149, 1635748149);
INSERT INTO `$prefix$nav` VALUES (2, 1, 1, 'zh', 0, '新闻资讯', 2, '/new', 5, 1, 3, '_self', 1, '', '', '', 1635748198, 1635748198);
INSERT INTO `$prefix$nav` VALUES (3, 1, 1, 'zh', 0, '产品', 2, '/product', 11, 1, 2, '_blank', 1, '', '', '', 1635762933, 1635762933);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$nav_cate
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$nav_cate`;
CREATE TABLE `$prefix$nav_cate` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '导航分类ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT NULL COMMENT '网站ID',
  `lang` varchar(255) DEFAULT 'zh',
  `title` varchar(120) DEFAULT NULL COMMENT '分类名称',
  `description` varchar(255) DEFAULT NULL COMMENT '分类简介',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='导航分类';

-- ----------------------------
-- Records of $prefix$nav_cate
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$nav_cate` VALUES (1, 1, 1, 'zh', '顶部导航', '公共顶部导航', 1635748140, 1635748140);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$recycle_bin
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$recycle_bin`;
CREATE TABLE `$prefix$recycle_bin` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `object_id` int(10) unsigned DEFAULT '0' COMMENT '删除内容 id',
  `module_id` int(10) unsigned DEFAULT NULL COMMENT '模型ID',
  `sub_id` int(11) DEFAULT NULL COMMENT '副表ID',
  `table_name` varchar(255) DEFAULT '' COMMENT '删除内容所在表名',
  `title` varchar(255) DEFAULT '' COMMENT '删除内容名称',
  `admin_id` bigint(20) unsigned DEFAULT '0' COMMENT '用户id',
  `name` varchar(255) DEFAULT '' COMMENT '删除人名称',
  `create_time` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='回收站';

-- ----------------------------
-- Records of $prefix$recycle_bin
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$role
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$role`;
CREATE TABLE `$prefix$role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `group` tinyint(11) NOT NULL DEFAULT '2' COMMENT '角色分组 1 系统默认 2 用户添加',
  `title` varchar(255) DEFAULT '' COMMENT '角色名称',
  `auth` varchar(500) DEFAULT '' COMMENT '权限',
  `status` tinyint(1) DEFAULT '1' COMMENT '角色状态 1 正常。2 删除',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='后台角色表';

-- ----------------------------
-- Records of $prefix$role
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$role` VALUES (1, 1, 1, '系统管理员', '*', 1, 1635406156, 1635406156);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$route
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$route`;
CREATE TABLE `$prefix$route` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '路由id',
  `seller_id` int(11) NOT NULL COMMENT '商户ID',
  `category_id` int(11) DEFAULT NULL COMMENT '栏目ID',
  `website_id` int(10) unsigned DEFAULT '1' COMMENT '网站ID',
  `lang` varchar(255) DEFAULT 'zh' COMMENT '语言',
  `sort` int(11) DEFAULT '1000' COMMENT '排序',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态;1:启用,2:不启用',
  `type` tinyint(4) DEFAULT '1' COMMENT 'URL规则类型;1:用户自定义;2:别名添加',
  `full_url` varchar(255) DEFAULT '' COMMENT '完整url',
  `url` varchar(255) DEFAULT '' COMMENT '实际显示的url',
  `pattern` varchar(255) DEFAULT NULL COMMENT '参数正则验证',
  `category_title` varchar(255) DEFAULT '' COMMENT '分类名称',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COMMENT='url路由表';

-- ----------------------------
-- Records of $prefix$route
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$route` VALUES (1, 1, 1, 1, 'zh', 1000, 1, 2, 'List/index?id=1', '/', '','首页', 1635478353, 1635478353);
INSERT INTO `$prefix$route` VALUES (5, 1, 5, 1, 'zh', 1000, 1, 1, 'List/index?id=5', '/new', '','新闻中心', 1635731380, 1635731380);
INSERT INTO `$prefix$route` VALUES (6, 1, 6, 1, 'zh', 1000, 1, 2, 'List/index?id=6', '/customer', '','客户', 1635738289, 1635738289);
INSERT INTO `$prefix$route` VALUES (7, 1, 7, 1, 'zh', 1000, 1, 2, 'List/index?id=7', '/introduction', '','品牌介绍', 1635738972, 1635738972);
INSERT INTO `$prefix$route` VALUES (9, 1, 5, 1, 'zh', 1000, 1, 1, 'Detail/index?cid=5', '/new/:id', '{\"id\":\"\\\\d+\",\"cid\":\"\\\\d+\"}','新闻中心详情页', 1635745148, 1635745148);
INSERT INTO `$prefix$route` VALUES (10, 1, 9, 1, 'zh', 1000, 1, 1, 'List/index?id=9', '/company_new', '','公司新闻', 1635748867, 1635748867);
INSERT INTO `$prefix$route` VALUES (11, 1, 10, 1, 'zh', 1000, 1, 1, 'List/index?id=10', '/industry_new','', '行业资讯', 1635748895, 1635748895);
INSERT INTO `$prefix$route` VALUES (12, 1, 11, 1, 'zh', 1000, 1, 1, 'List/index?id=11', '/product', '','产品', 1635761247, 1635761247);
INSERT INTO `$prefix$route` VALUES (13, 1, 11, 1, 'zh', 1000, 1, 1, 'Detail/index?cid=11', '/product/:id','{\"id\":\"\\\\d+\",\"cid\":\"\\\\d+\"}', '产品详情页', 1635766162, 1635766162);
INSERT INTO `$prefix$route` VALUES (14, 1, 9, 1, 'zh', 1000, 1, 1, 'Detail/index?cid=9', '/company_new/:id','{\"id\":\"\\\\d+\",\"cid\":\"\\\\d+\"}', '公司新闻详情页', 1635771256, 1635771256);
INSERT INTO `$prefix$route` VALUES (15, 1, 10, 1, 'zh', 1000, 1, 1, 'Detail/index?cid=10', '/industry_new/:id','{\"id\":\"\\\\d+\",\"cid\":\"\\\\d+\"}', '行业资讯详情页', 1635771276, 1635771276);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$seller
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$seller`;
CREATE TABLE `$prefix$seller` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商户ID',
  `username` varchar(80) NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(120) NOT NULL DEFAULT '' COMMENT '密码',
  `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号',
  `email` varchar(80) NOT NULL DEFAULT '' COMMENT '邮箱',
  `avatar` varchar(255) DEFAULT '' COMMENT '头像',
  `create_time` int(11) NOT NULL DEFAULT '0',
  `update_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of $prefix$seller
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$seller` VALUES (1, 'default', '040bd08a4290267535cd247b8ba2eca129d9fe9f', '18989898989', 'admin@admin.com', '', 1623295338, 1623295338);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$server
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$server`;
CREATE TABLE `$prefix$server` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `server_ip` varchar(255) DEFAULT '' COMMENT '服务器IP地址',
  `ssh_acount` varchar(255) DEFAULT '' COMMENT 'ssh账号',
  `ssh_password` varchar(255) DEFAULT '' COMMENT 'ssh密码',
  `ssh_port` int(11) DEFAULT '22' COMMENT 'ssh端口',
  `sort` int(11) DEFAULT '1000' COMMENT '分类排序',
  `status` tinyint(1) DEFAULT '1' COMMENT '1 正常 2 禁用',
  `create_time` int(11) DEFAULT '0',
  `update_time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='栏目表';

-- ----------------------------
-- Records of $prefix$server
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$site_map
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$site_map`;
CREATE TABLE `$prefix$site_map` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'sitemap ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT NULL COMMENT '站点ID',
  `loc` varchar(255) DEFAULT NULL COMMENT '域名',
  `priority` varchar(255) DEFAULT '0.1' COMMENT '优先级',
  `changefreq` varchar(255) DEFAULT 'weekly' COMMENT '变更周期',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='sitemap 表';

-- ----------------------------
-- Records of $prefix$site_map
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$sitemap_info
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$sitemap_info`;
CREATE TABLE `$prefix$sitemap_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'sitemap ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商家ID',
  `website_id` int(11) DEFAULT NULL COMMENT '站点ID',
  `sitemap_name` varchar(100) DEFAULT NULL COMMENT 'sitmap文件名称',
  `silian_name` varchar(100) DEFAULT NULL COMMENT '死链文件名称',
  `update_time` int(11) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='sitemap 文件表';

-- ----------------------------
-- Records of $prefix$sitemap_info
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$slide
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$slide`;
CREATE TABLE `$prefix$slide` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '幻灯片ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT NULL COMMENT '网站ID',
  `slide_cate_id` int(11) DEFAULT NULL COMMENT '分类ID',
  `lang` varchar(255) DEFAULT 'zh' COMMENT '语言',
  `title` varchar(120) DEFAULT NULL COMMENT '幻灯片标题',
  `sub_title` varchar(120) DEFAULT NULL COMMENT '幻灯片副标题',
  `url` varchar(120) DEFAULT NULL COMMENT '幻灯片地址',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态 1 正常 2 禁用',
  `sort` int(11) DEFAULT '100' COMMENT '排序',
  `attachment` int(11) DEFAULT NULL COMMENT '幻灯片图片',
  `description` varchar(255) DEFAULT NULL COMMENT '分类简介',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='幻灯片列表';

-- ----------------------------
-- Records of $prefix$slide
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$slide_cate
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$slide_cate`;
CREATE TABLE `$prefix$slide_cate` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '幻灯片分类',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT NULL COMMENT '网站ID',
  `lang` varchar(255) DEFAULT 'zh',
  `title` varchar(120) DEFAULT NULL COMMENT '分类名称',
  `description` varchar(255) DEFAULT NULL COMMENT '分类简介',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='幻灯片分类';

-- ----------------------------
-- Records of $prefix$slide_cate
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$social_account
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$social_account`;
CREATE TABLE `$prefix$social_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '社交账号ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `name` varchar(255) DEFAULT '' COMMENT '账号用户名',
  `account` varchar(255) DEFAULT '' COMMENT '账号ID',
  `type` tinyint(4) DEFAULT NULL COMMENT '账号类型 1 抖音 2 快手 3 头条 4百家号 5 微信公众号 6 Fackbook 7 Twitter 8 Linkedin 9 YouTube',
  `create_time` int(11) DEFAULT '0',
  `update_time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='社交账号表';

-- ----------------------------
-- Records of $prefix$social_account
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$social_marketing
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$social_marketing`;
CREATE TABLE `$prefix$social_marketing` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '社交营销ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT NULL COMMENT '站点ID',
  `image_id` int(11) DEFAULT NULL COMMENT '二维码/头像存放ID',
  `media_id` varchar(255) DEFAULT NULL COMMENT '媒体账号ID',
  `name` varchar(255) DEFAULT NULL COMMENT '媒体账号名称',
  `url` varchar(255) DEFAULT NULL COMMENT '主页链接',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='社交营销表';

-- ----------------------------
-- Records of $prefix$social_marketing
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$sub_content
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$sub_content`;
CREATE TABLE `$prefix$sub_content` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '内容主表ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `module_id` int(11) DEFAULT NULL,
  `lang` varchar(255) DEFAULT 'zh' COMMENT '语言',
  `main_id` int(11) DEFAULT NULL COMMENT '主表ID',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `sub_title` varchar(255) DEFAULT NULL COMMENT '副标题',
  `description` varchar(255) DEFAULT NULL,
  `content` text,
  `thumbnail` int(11) DEFAULT NULL COMMENT '缩略图',
  `cover` int(11) DEFAULT NULL COMMENT '详情页banner',
  `hits` int(11) DEFAULT '0' COMMENT '浏览数',
  `admin_id` int(11) DEFAULT '0' COMMENT '作者ID',
  `author` varchar(60) DEFAULT '' COMMENT '作者名称',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态 1 正常 2 禁用',
  `url` varchar(255) DEFAULT '' COMMENT '访问链接',
  `publish_time` datetime DEFAULT NULL COMMENT '发布时间',
  `is_top` tinyint(1) DEFAULT '2' COMMENT '置顶 1 置顶 2 否',
  `top_time` int(11) DEFAULT NULL COMMENT '置顶时间',
  `is_recommend` tinyint(1) DEFAULT '2' COMMENT '推荐 1 推荐 2 否',
  `sort` int(11) DEFAULT '10000' COMMENT '排序',
  `detail_tpl` varchar(255) DEFAULT NULL COMMENT '模版',
  `seo_title` varchar(255) DEFAULT '' COMMENT 'seo标题',
  `seo_keyword` varchar(255) DEFAULT '' COMMENT 'seo关键词',
  `seo_description` varchar(255) DEFAULT '' COMMENT 'seo描述',
  `is_del` tinyint(4) DEFAULT '1' COMMENT '删除 1 正常 2 删除',
  `delete_time` int(11) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COMMENT='模型副表';

-- ----------------------------
-- Records of $prefix$sub_content
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$sub_content` VALUES (1, 1, 1, 'zh', 6, '哪种材质更适合做定制品', NULL, '近几年，家装界悄然刮起一股定制风，而且这股风潮有愈刮愈烈之势，那么定制品有何优势魅力能征服越来越多的消费者?面对市场上琳琅满目的定制品，哪种材质更适合做定制品呢?', '<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">近几年，家装界悄然刮起一股定制风，而且这股风潮有愈刮愈烈之势，那么定制品有何优势魅力能征服越来越多的消费者?面对市场上琳琅满目的定制品，哪种材质更适合做定制品呢?</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">从经营模式的角度，传统模式是企业追求利润最大化，通过大规模生产来降低产品成本，最终把压力和风险转嫁给经销商，让经销商压库存，搞促销，最后资金压力越来越大，销售利润越来越低，被企业套得越来越深。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">而定制品彻底颠覆了这种模式，因为是一对一定制，所以库存极少，项目不会过多占用经销商资金，通过个性化设计、定制化产品反而会保证经销商的利润，经销商只要做好服务，做好口碑，有企业的强大支撑，生意只会越来越轻松、越来越好做。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">目前市面上的定制品以木质为主，其他材质的发展也很快，如：不锈钢、铝合金等，现在我们就来聊聊近几年发展很快的不锈钢定制品。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">不锈钢材质由于其硬度高加工难度大，表面上色工艺早期无突破导致颜色单一等原因，在5年前采用不锈钢制作定制品的是非常少的。近年来，随着科学技术不断突破，不锈钢的加工工艺及上色难题已经得到非常好的解决了，因此，目前采用不锈钢进行全屋定制品制作已经成为可能并且因为不锈钢天生的一些无法比拟的优势，使得不锈钢定制品越来越得到市场的认可，消费者的青睐。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp; <img src=\"http://demo.huocms.com/storage/image/20211101/5d4c96927de514cec71c984f6b97e083.jpg\" alt=\"\" width=\"279\" height=\"186\" />&nbsp; &nbsp; &nbsp; <img src=\"http://demo.huocms.com/storage/image/20211101/47f987cf9af227a2d9b18ad8cf6d127d.jpg\" alt=\"\" width=\"279\" height=\"186\" /> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"http://demo.huocms.com/storage/image/20211101/17003e2dc2243a5c38fe9ae4a8c23735.jpg\" alt=\"\" width=\"278\" height=\"186\" /></p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp;</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">我们可以发现，不锈钢由于其天然的材质特性而具备了许多与生俱来无可比拟的优势，同时随着科技的进步各种工艺技术、加工设备的成熟运用，不锈钢早已摆脱传统印象中冰冷笨重、傻大黑粗的大汉形象，变身为俏丽温雅、身怀绝招的邻家小哥，成为追求品质个性的90后、00后客户的首先。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp;</p>', 19, 14, 89, 13, 'admin', 1, '', '2021-11-01 14:43:00', 2, 1635736700, 2, 0, NULL, '', '', '', 1, NULL, 1635736625, 1635775276);
INSERT INTO `$prefix$sub_content` VALUES (2, 1, 1, 'zh', 7, '厨房装修五大事项，做好了给你一个舒适的厨房', NULL, '从经营模式的角度，传统模式是企业追求利润最大化，通过大规模生产来降低产品成本，最终把压力和风险转嫁给经销商，让经销商压库存，搞促销，最后资金压力越来越大，销售利润越来越低，被企业套得越来越深。', '<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">近几年，家装界悄然刮起一股定制风，而且这股风潮有愈刮愈烈之势，那么定制品有何优势魅力能征服越来越多的消费者?面对市场上琳琅满目的定制品，哪种材质更适合做定制品呢?</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">从经营模式的角度，传统模式是企业追求利润最大化，通过大规模生产来降低产品成本，最终把压力和风险转嫁给经销商，让经销商压库存，搞促销，最后资金压力越来越大，销售利润越来越低，被企业套得越来越深。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">而定制品彻底颠覆了这种模式，因为是一对一定制，所以库存极少，项目不会过多占用经销商资金，通过个性化设计、定制化产品反而会保证经销商的利润，经销商只要做好服务，做好口碑，有企业的强大支撑，生意只会越来越轻松、越来越好做。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">目前市面上的定制品以木质为主，其他材质的发展也很快，如：不锈钢、铝合金等，现在我们就来聊聊近几年发展很快的不锈钢定制品。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">不锈钢材质由于其硬度高加工难度大，表面上色工艺早期无突破导致颜色单一等原因，在5年前采用不锈钢制作定制品的是非常少的。近年来，随着科学技术不断突破，不锈钢的加工工艺及上色难题已经得到非常好的解决了，因此，目前采用不锈钢进行全屋定制品制作已经成为可能并且因为不锈钢天生的一些无法比拟的优势，使得不锈钢定制品越来越得到市场的认可，消费者的青睐。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp; <img src=\"http://demo.huocms.com/storage/image/20211101/5d4c96927de514cec71c984f6b97e083.jpg\" alt=\"\" width=\"279\" height=\"186\" />&nbsp; &nbsp; &nbsp; <img src=\"http://demo.huocms.com/storage/image/20211101/47f987cf9af227a2d9b18ad8cf6d127d.jpg\" alt=\"\" width=\"279\" height=\"186\" /> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"http://demo.huocms.com/storage/image/20211101/17003e2dc2243a5c38fe9ae4a8c23735.jpg\" alt=\"\" width=\"278\" height=\"186\" /></p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp;</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">我们可以发现，不锈钢由于其天然的材质特性而具备了许多与生俱来无可比拟的优势，同时随着科技的进步各种工艺技术、加工设备的成熟运用，不锈钢早已摆脱传统印象中冰冷笨重、傻大黑粗的大汉形象，变身为俏丽温雅、身怀绝招的邻家小哥，成为追求品质个性的90后、00后客户的首先。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp;</p>', 18, 14, 20, 13, 'admin', 1, '', '2021-11-01 14:42:42', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635737755, 1635775260);
INSERT INTO `$prefix$sub_content` VALUES (3, 1, 1, 'zh', 8, '做不锈钢厨柜就要选有前景的企业', NULL, '现今，家居建材行业竞争激烈，在发展过程中，注定了辉煌与“乱象丛生”并存，调查证明，三四线城市...', '<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">现今，家居建材行业竞争激烈，在发展过程中，注定了辉煌与&ldquo;乱象丛生&rdquo;并存，调查证明，三四线城市...</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">从经营模式的角度，传统模式是企业追求利润最大化，通过大规模生产来降低产品成本，最终把压力和风险转嫁给经销商，让经销商压库存，搞促销，最后资金压力越来越大，销售利润越来越低，被企业套得越来越深。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">而定制品彻底颠覆了这种模式，因为是一对一定制，所以库存极少，项目不会过多占用经销商资金，通过个性化设计、定制化产品反而会保证经销商的利润，经销商只要做好服务，做好口碑，有企业的强大支撑，生意只会越来越轻松、越来越好做。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">目前市面上的定制品以木质为主，其他材质的发展也很快，如：不锈钢、铝合金等，现在我们就来聊聊近几年发展很快的不锈钢定制品。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">不锈钢材质由于其硬度高加工难度大，表面上色工艺早期无突破导致颜色单一等原因，在5年前采用不锈钢制作定制品的是非常少的。近年来，随着科学技术不断突破，不锈钢的加工工艺及上色难题已经得到非常好的解决了，因此，目前采用不锈钢进行全屋定制品制作已经成为可能并且因为不锈钢天生的一些无法比拟的优势，使得不锈钢定制品越来越得到市场的认可，消费者的青睐。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp; <img src=\"http://demo.huocms.com/storage/image/20211101/5d4c96927de514cec71c984f6b97e083.jpg\" alt=\"\" width=\"279\" height=\"186\" />&nbsp; &nbsp; &nbsp; <img src=\"http://demo.huocms.com/storage/image/20211101/47f987cf9af227a2d9b18ad8cf6d127d.jpg\" alt=\"\" width=\"279\" height=\"186\" /> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"http://demo.huocms.com/storage/image/20211101/17003e2dc2243a5c38fe9ae4a8c23735.jpg\" alt=\"\" width=\"278\" height=\"186\" /></p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp;</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">我们可以发现，不锈钢由于其天然的材质特性而具备了许多与生俱来无可比拟的优势，同时随着科技的进步各种工艺技术、加工设备的成熟运用，不锈钢早已摆脱传统印象中冰冷笨重、傻大黑粗的大汉形象，变身为俏丽温雅、身怀绝招的邻家小哥，成为追求品质个性的90后、00后客户的首先。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp;</p>', 17, 0, 7, 13, 'admin', 1, '', '2021-11-01 14:42:24', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635737900, 1635775264);
INSERT INTO `$prefix$sub_content` VALUES (4, 1, 1, 'zh', 9, '舒适智能马桶的定义', NULL, '智能马桶具有齐备的功能很重要，但一个好的智能马桶，质量的优劣也很重要！', '<p>&nbsp;</p>\n<div class=\"news_box_link_in\" style=\"margin: 0px; padding: 0px; border: 0px; font-weight: normal; vertical-align: baseline;\">\n<p style=\"margin: 0px; padding: 0px; border: 0px; font-weight: normal; vertical-align: baseline; font-size: 14px; line-height: 24px; color: #666666; overflow: hidden; text-overflow: ellipsis; display: -webkit-box; -webkit-line-clamp: 2; -webkit-box-orient: vertical; font-family: MicrosoftYaHei;\">智能马桶具有齐备的功能很重要，但一个好的智能马桶，质量的优劣也很重要！</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">近几年，家装界悄然刮起一股定制风，而且这股风潮有愈刮愈烈之势，那么定制品有何优势魅力能征服越来越多的消费者?面对市场上琳琅满目的定制品，哪种材质更适合做定制品呢?</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">从经营模式的角度，传统模式是企业追求利润最大化，通过大规模生产来降低产品成本，最终把压力和风险转嫁给经销商，让经销商压库存，搞促销，最后资金压力越来越大，销售利润越来越低，被企业套得越来越深。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">而定制品彻底颠覆了这种模式，因为是一对一定制，所以库存极少，项目不会过多占用经销商资金，通过个性化设计、定制化产品反而会保证经销商的利润，经销商只要做好服务，做好口碑，有企业的强大支撑，生意只会越来越轻松、越来越好做。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">目前市面上的定制品以木质为主，其他材质的发展也很快，如：不锈钢、铝合金等，现在我们就来聊聊近几年发展很快的不锈钢定制品。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">不锈钢材质由于其硬度高加工难度大，表面上色工艺早期无突破导致颜色单一等原因，在5年前采用不锈钢制作定制品的是非常少的。近年来，随着科学技术不断突破，不锈钢的加工工艺及上色难题已经得到非常好的解决了，因此，目前采用不锈钢进行全屋定制品制作已经成为可能并且因为不锈钢天生的一些无法比拟的优势，使得不锈钢定制品越来越得到市场的认可，消费者的青睐。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp; <img src=\"http://demo.huocms.com/storage/image/20211101/5d4c96927de514cec71c984f6b97e083.jpg\" alt=\"\" width=\"279\" height=\"186\" />&nbsp; &nbsp; &nbsp; <img src=\"http://demo.huocms.com/storage/image/20211101/47f987cf9af227a2d9b18ad8cf6d127d.jpg\" alt=\"\" width=\"279\" height=\"186\" /> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"http://demo.huocms.com/storage/image/20211101/17003e2dc2243a5c38fe9ae4a8c23735.jpg\" alt=\"\" width=\"278\" height=\"186\" /></p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp;</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">我们可以发现，不锈钢由于其天然的材质特性而具备了许多与生俱来无可比拟的优势，同时随着科技的进步各种工艺技术、加工设备的成熟运用，不锈钢早已摆脱传统印象中冰冷笨重、傻大黑粗的大汉形象，变身为俏丽温雅、身怀绝招的邻家小哥，成为追求品质个性的90后、00后客户的首先。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp;</p>\n</div>', 16, 0, 80, 13, 'admin', 1, '', '2021-11-01 14:42:04', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635738046, 1635822232);
INSERT INTO `$prefix$sub_content` VALUES (5, 1, 1, 'zh', 10, '向好生活提案，你需要一个更健康厕所环境', NULL, '你是不是也经历过这样的苦恼？一边着急上班，一边还要排队等着家里人上厕所', '<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\"><span style=\"color: #666666; font-family: MicrosoftYaHei;\"><span style=\"font-size: 15px;\">你是不是也经历过这样的苦恼？一边着急上班，一边还要排队等着家里人上厕所。。</span></span></p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">近几年，家装界悄然刮起一股定制风，而且这股风潮有愈刮愈烈之势，那么定制品有何优势魅力能征服越来越多的消费者?面对市场上琳琅满目的定制品，哪种材质更适合做定制品呢?</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">从经营模式的角度，传统模式是企业追求利润最大化，通过大规模生产来降低产品成本，最终把压力和风险转嫁给经销商，让经销商压库存，搞促销，最后资金压力越来越大，销售利润越来越低，被企业套得越来越深。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">而定制品彻底颠覆了这种模式，因为是一对一定制，所以库存极少，项目不会过多占用经销商资金，通过个性化设计、定制化产品反而会保证经销商的利润，经销商只要做好服务，做好口碑，有企业的强大支撑，生意只会越来越轻松、越来越好做。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">目前市面上的定制品以木质为主，其他材质的发展也很快，如：不锈钢、铝合金等，现在我们就来聊聊近几年发展很快的不锈钢定制品。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">不锈钢材质由于其硬度高加工难度大，表面上色工艺早期无突破导致颜色单一等原因，在5年前采用不锈钢制作定制品的是非常少的。近年来，随着科学技术不断突破，不锈钢的加工工艺及上色难题已经得到非常好的解决了，因此，目前采用不锈钢进行全屋定制品制作已经成为可能并且因为不锈钢天生的一些无法比拟的优势，使得不锈钢定制品越来越得到市场的认可，消费者的青睐。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp; <img src=\"http://demo.huocms.com/storage/image/20211101/5d4c96927de514cec71c984f6b97e083.jpg\" alt=\"\" width=\"279\" height=\"186\" />&nbsp; &nbsp; &nbsp; <img src=\"http://demo.huocms.com/storage/image/20211101/47f987cf9af227a2d9b18ad8cf6d127d.jpg\" alt=\"\" width=\"279\" height=\"186\" /> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"http://demo.huocms.com/storage/image/20211101/17003e2dc2243a5c38fe9ae4a8c23735.jpg\" alt=\"\" width=\"278\" height=\"186\" /></p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp;</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">我们可以发现，不锈钢由于其天然的材质特性而具备了许多与生俱来无可比拟的优势，同时随着科技的进步各种工艺技术、加工设备的成熟运用，不锈钢早已摆脱传统印象中冰冷笨重、傻大黑粗的大汉形象，变身为俏丽温雅、身怀绝招的邻家小哥，成为追求品质个性的90后、00后客户的首先。</p>\n<p style=\"margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: #666666; font-family: MicrosoftYaHei; font-size: 15px; background-color: #ffffff;\">&nbsp;</p>', 15, 14, 111, 13, 'admin', 1, '', '2021-11-01 14:41:48', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635738144, 1635822252);
INSERT INTO `$prefix$sub_content` VALUES (6, 1, 2, 'zh', 1, '客户一', NULL, NULL, '', 7, 0, 0, 13, 'admin', 1, '', '2021-11-01 14:21:23', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635738391, 1635738391);
INSERT INTO `$prefix$sub_content` VALUES (7, 1, 2, 'zh', 2, '客户二', NULL, NULL, '', 8, 0, 0, 13, 'admin', 1, '', '2021-11-01 14:21:27', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635738420, 1635738420);
INSERT INTO `$prefix$sub_content` VALUES (8, 1, 2, 'zh', 3, '客户三', NULL, NULL, '', 9, 0, 0, 13, 'admin', 1, '', '2021-11-01 14:21:31', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635738433, 1635738433);
INSERT INTO `$prefix$sub_content` VALUES (9, 1, 2, 'zh', 4, '客户四', NULL, NULL, '', 10, 0, 0, 13, 'admin', 1, '', '2021-11-01 14:21:34', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635738501, 1635738501);
INSERT INTO `$prefix$sub_content` VALUES (10, 1, 2, 'zh', 5, '客户五', NULL, NULL, '', 11, 0, 0, 13, 'admin', 1, '', '2021-11-01 14:21:38', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635738599, 1635738599);
INSERT INTO `$prefix$sub_content` VALUES (11, 1, 2, 'zh', 6, '客户六', NULL, NULL, '', 12, 0, 0, 13, 'admin', 1, '', '2021-11-01 14:21:41', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635738610, 1635738610);
INSERT INTO `$prefix$sub_content` VALUES (12, 1, 2, 'zh', 7, '客户七', NULL, NULL, '', 8, 0, 0, 13, 'admin', 1, '', '2021-11-01 14:27:15', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635748035, 1635748035);
INSERT INTO `$prefix$sub_content` VALUES (13, 1, 2, 'zh', 8, '客户八', NULL, NULL, '', 10, 0, 0, 13, 'admin', 1, '', '2021-11-01 14:27:36', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635748056, 1635748056);
INSERT INTO `$prefix$sub_content` VALUES (15, 1, 3, 'zh', 2, '高端浴缸', NULL, '在古代文化中，竞技场，作为力量比拼的场所，承载着狂热的宗教意义。尽管这类观赏性运动的传统还保留至今，但现在再也不会为过去简单的沙竞技场提供充足的空间。 ', '', 23, 29, 10, 13, 'admin', 1, '', '2021-11-01 18:23:43', 1, 1635762895, 2, 0, NULL, '', '', '', 1, NULL, 1635762223, 1635775040);
INSERT INTO `$prefix$sub_content` VALUES (16, 1, 3, 'zh', 3, '龙头组合', NULL, NULL, '', 0, 0, 0, 13, 'admin', 1, '', '2021-11-01 18:24:32', 2, NULL, 2, 0, NULL, '', '', '', 2, 1635762866, 1635762272, 1635762866);
INSERT INTO `$prefix$sub_content` VALUES (17, 1, 3, 'zh', 4, '龙头组合', NULL, '一体式置物架 / 出水口配置:1 个右边单孔 / 安装类型:下沉式', '', 27, 29, 2, 13, 'admin', 1, '', '2021-11-01 18:25:27', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635762327, 1635773230);
INSERT INTO `$prefix$sub_content` VALUES (18, 1, 3, 'zh', 5, '老式混水阀', NULL, '一体式置物架 / 出水口配置:1 个右边单孔 / 安装类型:下沉式', '', 28, 29, 1, 13, 'admin', 1, '', '2021-11-01 18:25:47', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635762347, 1635773233);
INSERT INTO `$prefix$sub_content` VALUES (19, 1, 3, 'zh', 6, '面盆龙头', NULL, '现代简约圆形艺术洗手盆，卫生间陶瓷', '', 24, 29, 0, 13, 'admin', 1, '', '2021-11-01 18:26:07', 1, 1635762861, 2, 0, NULL, '', '', '', 1, NULL, 1635762367, 1635765571);
INSERT INTO `$prefix$sub_content` VALUES (20, 1, 3, 'zh', 7, '菜盆龙头', NULL, 'B.1系列线条圆润，设计优雅经典，于功能之上呈献舒适体验，操作简易并拥有通用于各个卫浴功能的适配龙头，包括盥洗，淋浴，沐浴以及便洗。', '', 25, 29, 1, 13, 'admin', 1, '', '2021-11-01 18:26:25', 2, NULL, 2, 0, NULL, '', '', '', 1, NULL, 1635762385, 1635766294);
INSERT INTO `$prefix$sub_content` VALUES (21, 1, 3, 'zh', 8, '酒店马桶', NULL, '适配私人浴室或是客用浴室的柔和造型：B.1系列线条圆润，设计优雅经典，于功能之上呈献舒适体验，操作简易并拥有通用于各个卫浴功能的适配龙头，包括盥洗，淋浴，沐浴以及便洗。', '', 26, 29, 0, 13, 'admin', 1, '', '2021-11-01 18:26:55', 1, 1635762853, 2, 0, NULL, '', '', '', 1, NULL, 1635762415, 1635765544);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$sys_setting
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$sys_setting`;
CREATE TABLE `$prefix$sys_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '系统设置ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `parent_id` int(10) unsigned DEFAULT '0' COMMENT '分组ID',
  `group` varchar(255) DEFAULT '' COMMENT '配置分组',
  `form_title` varchar(255) DEFAULT '' COMMENT '表单名称',
  `title` varchar(255) DEFAULT '' COMMENT '配置名称',
  `value` varchar(255) DEFAULT '' COMMENT '配置值',
  `remark` varchar(255) DEFAULT '' COMMENT '描述',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态',
  `sort` int(11) DEFAULT '100' COMMENT '排序',
  `create_time` int(11) DEFAULT '0',
  `update_time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8mb4 COMMENT='系统配置';

-- ----------------------------
-- Records of $prefix$sys_setting
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$sys_setting` VALUES (1, 1, 0, 'upload', '文件上传设置', 'upload_setting', '', '', 1, 2, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (2, 1, 1, 'upload', '最大上传个数', 'max_files', '4', '多文件上传，单次可上传个数', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (3, 1, 1, 'upload', '分片上传，文件大小', 'chunk_size', '1024', '设置分片文件大小(单位kb)', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (4, 1, 1, 'upload', '图片大小设置', 'image_size', '10240', '设置图片上传大小(单位kb)', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (5, 1, 1, 'upload', '图片格式设置', 'image_ext', 'webp,jpg,png,ico,bmp,gif,jpeg', '设置上传图片类型', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (6, 1, 1, 'upload', '视频大小设置', 'video_size', '10240', '设置视频上传大小(单位kb)', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (7, 1, 1, 'upload', '视频类型设置', 'video_ext', 'mp4,avi,3gp,rmvb,mov', '设置视频上传类型', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (8, 1, 1, 'upload', '音频大小设置', 'audio_size', '10240', '设置音频上传大小(单位kb)', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (9, 1, 1, 'upload', '音频类型设置', 'audio_ext', 'mp3,mpeg,wma,mid', '设置音频上传类型', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (10, 1, 1, 'upload', '压缩包设置', 'zip_size', '10240', '设置上传文件大小(单位kb)', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (11, 1, 1, 'upload', '压缩包类型设置', 'zip_ext', 'rar,zip', '设置文件上传类型', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (12, 1, 1, 'upload', '分片上传触发', 'chunk_condition', '51200', '触发分片上传大小(单位kb)', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (13, 1, 1, 'upload', '文件存储设置', 'storage', 'local', '', 1, 20, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (14, 1, 13, 'upload', '本地存储', 'local', 'local', '', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (15, 1, 13, 'upload', '阿里云', 'aliyun', 'aliyun', '', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (16, 1, 13, 'upload', '七牛云', 'qiniu', 'qiniu', '', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (17, 1, 0, 'email', '系统邮箱设置', 'sys_email_setting', '', '', 1, 1, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (18, 1, 17, 'email', '发件箱账号', 'email_send_account', 'test@admin.com', '', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (19, 1, 17, 'email', '发件箱密码', 'email_password', 'Zhihuo2020', '', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (20, 1, 17, 'email', '发件箱类型', 'email_type', 'ali', '163，新浪，阿里，腾讯，QQ', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (21, 1, 17, 'email', '收件箱账号', 'email_get_account', 'test@admin.com', '', 1, 12, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (23, 1, 0, 'sem', 'SEM账号设置', 'sem_setting', '', '', 2, 3, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (25, 1, 23, 'sem', '百度', 'baidu_sem', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (26, 1, 25, 'sem', '账号', 'baidu_sem_account', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (27, 1, 25, 'sem', '密码', 'baidu_sem_passowrd', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (28, 1, 25, 'sem', 'Token', 'baidu_sem_token', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (29, 1, 23, 'sem', '谷歌', 'google_sem', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (30, 1, 29, 'sem', '账号', 'google_sem_account', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (31, 1, 29, 'sem', '密码', 'google_sem_passowrd', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (32, 1, 29, 'sem', 'Token', 'google_sem_token', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (33, 1, 23, 'sem', '搜狗', 'sougou_sem', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (34, 1, 33, 'sem', '账号', 'sougou_sem_account', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (35, 1, 33, 'sem', '密码', 'sougou_sem_password', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (36, 1, 33, 'sem', 'Token', 'sougou_sem_token', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (37, 1, 23, 'sem', '360', '360_sem', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (38, 1, 37, 'sem', '账号', '360_sem_account', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (39, 1, 37, 'sem', '密码', '360_sem_password', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (40, 1, 37, 'sem', 'Token', '360_sem_token', '', '', 2, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (45, 1, 0, 'analysis', '统计分析账号', 'analysis_setting', '', '', 1, 4, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (46, 1, 45, 'analysis', '百度统计', 'baidu_analysis', '', '', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (47, 1, 46, 'analysis', '账号', 'baidu_analysis_account', '', '', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (48, 1, 46, 'analysis', '密码', 'baidu_analysis_password', '', '', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (49, 1, 46, 'analysis', 'token', 'baidu_analysis_token', '', '', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (50, 1, 45, 'analysis', '谷歌统计', 'google_analysis', '', '', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (51, 1, 50, 'analysis', '账号', 'google_analysis_account', '', '', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (52, 1, 50, 'analysis', '密码', 'google_analysis_password', '', '', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (53, 1, 50, 'analysis', 'token', 'google_analysis_token', '', '', 1, 100, 1625731449, 1625731449);
INSERT INTO `$prefix$sys_setting` VALUES (54, 1, 16, 'upload', '接收密钥ID', 'qiniu_accessKeyId', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (55, 1, 16, 'upload', '接收密钥密码', 'qiniu_accessKeySecret', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (56, 1, 16, 'upload', '根地址', 'qiniu_storageRoot', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (57, 1, 16, 'upload', '容器名', 'qiniu_bucket', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (58, 1, 16, 'upload', '协议头', 'qiniu_protocolHeader', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (59, 1, 13, 'upload', '腾讯云', 'tencent', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (60, 1, 59, 'upload', '接收密钥ID', 'tencent_accessKeyId', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (61, 1, 59, 'upload', '接收密钥密码', 'tencent_accessKeySecret', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (62, 1, 59, 'upload', '地区', 'tencent_region', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (63, 1, 59, 'upload', '容器名', 'tencent_bucket', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (64, 1, 59, 'upload', '协议头', 'tencent_protocolHeader', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (65, 1, 15, 'upload', '接收密钥ID', 'aliyun_accessKeyId', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (66, 1, 15, 'upload', '接收密钥密码', 'aliyun_accessKeySecret', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (67, 1, 15, 'upload', '根地址', 'aliyun_storageRoot', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (68, 1, 15, 'upload', '容器名', 'aliyun_bucket', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (69, 1, 20, 'sys_email', '阿里企业邮箱', 'ali', 'ali', '', 1, 201, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (70, 1, 20, 'sys_email', '新浪邮箱', 'sina', 'sina', '', 1, 202, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (71, 1, 20, 'sys_email', '163邮箱', '163', '163', '', 1, 203, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (72, 1, 20, 'sys_email', 'QQ邮箱', 'qq', 'qq', '', 1, 204, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (73, 1, 20, 'sys_email', 'office365邮箱', '365', '365', '', 1, 205, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (75, 1, 1, 'upload', '文件大小', 'file_size', '10240', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (76, 1, 1, 'upload', '文件类型', 'file_ext', 'exe,doc,ppt,xls,wps,txt,json,xlsx', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (78, 1, 0, 'others', '第三方配置', 'other_settings', '', '其他第三方配置', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (79, 1, 78, 'others', 'Suwork配置', 'suwork', '', '', 1, 781, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (80, 1, 79, 'others', 'Suwork APPID', 'suwork_appid', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (81, 1, 79, 'others', 'Suwork 密钥', 'suwork_secret', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (82, 1, 78, 'others', '关键词排名查询配置', 'keywords_search', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (83, 1, 82, 'others', '站长工具', 'toolz', '', '', 2, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (84, 1, 82, 'others', '5118', 'five_one_one', '', '', 1, 783, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (85, 1, 78, 'others', '谷歌翻译配置', 'google_trans_token', '', '', 2, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (86, 1, 84, 'others', '百度PC', 'five_baidu_pc', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (87, 1, 84, 'others', '百度移动', 'five_baidu_mob', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (88, 1, 84, 'others', '360PC', 'haosou_pc', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (89, 1, 84, 'others', '搜狗移动', 'sougou_mob', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (90, 1, 84, 'others', '自动查询频率', 'keywords_search_time', 'day', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (91, 1, 0, 'company', '公司配置', 'company_setting', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (92, 1, 91, 'company', '公司名称', 'company_name', '智火信息科技有限公司', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (93, 1, 91, 'company', '公司地址', 'company_address', '上海市隆昌路城市概念8号楼南区C07', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (94, 1, 91, 'company', '公司电话', 'company_phone', '4000-700360', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (95, 1, 91, 'company', '公司邮箱', 'company_email', 'vip@zhco.com', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (96, 1, 78, 'others', '词爪配置', 'cizhua', '', '', 1, 782, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (97, 1, 96, 'others', '词爪 APPID', 'cizhua_appid', '', '', 1, 100, 0, 0);
INSERT INTO `$prefix$sys_setting` VALUES (98, 1, 96, 'others', '词爪 密钥', 'cizhua_secret', '', '', 1, 100, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$tag
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$tag`;
CREATE TABLE `$prefix$tag` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类id',
  `seller_id` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT NULL COMMENT '网站ID',
  `lang` varchar(255) DEFAULT NULL COMMENT '语言',
  `title` varchar(255) DEFAULT '' COMMENT '标签名称',
  `unique_tag` varchar(255) DEFAULT NULL COMMENT '标签唯一标识',
  `status` tinyint(3) unsigned DEFAULT '1' COMMENT '状态,1:正常,2:隐藏',
  `first_letter` char(1) DEFAULT NULL COMMENT '排序',
  `sort` tinyint(3) DEFAULT NULL COMMENT '排序',
  `is_recommend` tinyint(3) unsigned DEFAULT '2' COMMENT '是否推荐;1:推荐;2:不推荐',
  `article_count` bigint(20) unsigned DEFAULT '0' COMMENT '标签文章数',
  `tag_hit` int(10) unsigned DEFAULT '0' COMMENT '标签点击数',
  `seo_title` varchar(255) DEFAULT '' COMMENT 'title',
  `seo_keywords` varchar(255) DEFAULT '' COMMENT 'keywords',
  `seo_description` varchar(255) DEFAULT '' COMMENT 'description',
  `is_del` tinyint(1) DEFAULT '1' COMMENT '删除 1 正常 2 删除',
  `delete_time` int(11) DEFAULT '0',
  `create_time` int(11) DEFAULT '0',
  `update_time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='文章标签表';

-- ----------------------------
-- Records of $prefix$tag
-- ----------------------------
BEGIN;
INSERT INTO `$prefix$tag` VALUES (1, 1, 2, 'zh', '用户体验', NULL, 1, NULL, NULL, 2, 0, 0, '', '', '', 1, 0, 1635780788, 1635780788);
INSERT INTO `$prefix$tag` VALUES (2, 1, 2, 'zh', '交互设计', NULL, 1, NULL, NULL, 2, 0, 0, '', '', '', 1, 0, 1635780797, 1635780797);
INSERT INTO `$prefix$tag` VALUES (3, 1, 2, 'zh', '移动平台开发', NULL, 1, NULL, NULL, 2, 0, 0, '', '', '', 1, 0, 1635780808, 1635780808);
INSERT INTO `$prefix$tag` VALUES (4, 1, 2, 'zh', '自适应', NULL, 1, NULL, NULL, 2, 0, 0, '', '', '', 1, 0, 1635780814, 1635780814);
COMMIT;

-- ----------------------------
-- Table structure for $prefix$tag_sub_content
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$tag_sub_content`;
CREATE TABLE `$prefix$tag_sub_content` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类id',
  `seller_id` int(10) unsigned DEFAULT NULL COMMENT '商户ID',
  `tag_id` int(10) unsigned DEFAULT NULL COMMENT '标签 id',
  `sub_content_id` int(10) unsigned DEFAULT NULL COMMENT '内容 id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章标签关联表';

-- ----------------------------
-- Records of $prefix$tag_sub_content
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$test_example
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$test_example`;
CREATE TABLE `$prefix$test_example` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `seller_id` bigint(20) unsigned DEFAULT NULL COMMENT '商户ID',
  `lang` varchar(255) DEFAULT 'zh' COMMENT '语言标识',
  `lang_pid` int(11) DEFAULT '0' COMMENT '语言锚点',
  `sub_id` bigint(20) unsigned DEFAULT NULL COMMENT '副表ID',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='测试模型表';

-- ----------------------------
-- Records of $prefix$test_example
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$theme
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$theme`;
CREATE TABLE `$prefix$theme` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '模板ID',
  `seller_id` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(10) unsigned DEFAULT '1' COMMENT '网站ID',
  `lang` varchar(255) DEFAULT 'zh',
  `is_active` tinyint(3) unsigned DEFAULT '2' COMMENT '模板状态 1 正在使用 2 未使用 ',
  `theme` varchar(255) DEFAULT '' COMMENT '主题目录名，用于主题的唯一标识',
  `name` varchar(120) DEFAULT '' COMMENT '主题名称',
  `description` varchar(255) DEFAULT '' COMMENT '主题介绍',
  `keywords` varchar(255) DEFAULT '' COMMENT '主题关键词',
  `author` varchar(255) DEFAULT '' COMMENT '主题作者',
  `url` varchar(255) DEFAULT '' COMMENT '预览地址',
  `thumb` varchar(60) DEFAULT '' COMMENT '缩略图',
  `sort` tinyint(3) unsigned DEFAULT '1',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='主题表';

-- ----------------------------
-- Records of $prefix$theme
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$theme_file
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$theme_file`;
CREATE TABLE `$prefix$theme_file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '模板文件ID',
  `seller_id` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT '1' COMMENT '网站ID',
  `lang` varchar(255) DEFAULT 'zh',
  `theme_id` int(11) DEFAULT NULL COMMENT '模板ID',
  `file` varchar(255) DEFAULT NULL COMMENT '模板路径，相对根目录',
  `name` varchar(255) DEFAULT '' COMMENT '模板文件名称',
  `description` varchar(255) DEFAULT '' COMMENT '文件描述',
  `action` varchar(255) DEFAULT '' COMMENT '操作',
  `theme_name` varchar(255) DEFAULT NULL COMMENT '模板名称',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `is_public` tinyint(3) unsigned DEFAULT '2' COMMENT '公共模块 1 是 2 否',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='模板文件配置表';

-- ----------------------------
-- Records of $prefix$theme_file
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$visit_log
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$visit_log`;
CREATE TABLE `$prefix$visit_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seller_id` int(11) NOT NULL DEFAULT '1',
  `referrer` varchar(255) DEFAULT NULL COMMENT '来源网址',
  `website_id` int(11) DEFAULT NULL COMMENT '站点ID',
  `domain` varchar(255) DEFAULT NULL COMMENT '域名',
  `ip` varchar(255) DEFAULT NULL COMMENT '访问IP',
  `url` varchar(255) DEFAULT NULL COMMENT '访问地址',
  `visited_time` date DEFAULT NULL COMMENT '访问日期',
  `visited_area` varchar(255) DEFAULT NULL COMMENT '访问地址',
  `visited_device` varchar(255) DEFAULT NULL COMMENT '访问设备',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='前台用户访问日志表';

-- ----------------------------
-- Records of $prefix$visit_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$website
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$website`;
CREATE TABLE `$prefix$website` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '网站ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `title` varchar(255) DEFAULT '1' COMMENT '网站名称',
  `domain` varchar(255) DEFAULT NULL COMMENT '网站域名',
  `parent_id` int(11) DEFAULT '0' COMMENT '父站点',
  `sitemap_url` varchar(255) DEFAULT NULL COMMENT 'sitemap 地址',
  `silian_url` varchar(255) DEFAULT NULL COMMENT '死链地址',
  `status` tinyint(4) DEFAULT '1' COMMENT '网站状态 1 正常 2 禁用',
  `create_time` int(11) DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='网站表';

-- ----------------------------
-- Records of $prefix$website
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$website_inquiry_email
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$website_inquiry_email`;
CREATE TABLE `$prefix$website_inquiry_email` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `seller_id` int(11) NOT NULL DEFAULT '1',
  `website_id` int(11) DEFAULT NULL,
  `inquiry_email_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='收件箱网站关联表';

-- ----------------------------
-- Records of $prefix$website_inquiry_email
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$website_lang
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$website_lang`;
CREATE TABLE `$prefix$website_lang` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '网站语言关联表ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT '0' COMMENT '网站ID',
  `title` varchar(255) DEFAULT '' COMMENT '语言名称',
  `lang` varchar(30) DEFAULT '' COMMENT '语言标识',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='网站语言关联表';

-- ----------------------------
-- Records of $prefix$website_lang
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$website_server
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$website_server`;
CREATE TABLE `$prefix$website_server` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) DEFAULT NULL,
  `type` tinyint(1) DEFAULT NULL COMMENT '1 本地服务器 2 自定义服务器',
  `server_ip` varchar(255) NOT NULL DEFAULT '' COMMENT '服务器IP地址',
  `ssh_account` varchar(255) NOT NULL DEFAULT '' COMMENT 'ssh账号',
  `ssh_password` varchar(255) NOT NULL DEFAULT '' COMMENT 'ssh密码',
  `ssh_port` int(11) NOT NULL DEFAULT '22' COMMENT 'ssh端口',
  `root_path` varchar(255) DEFAULT NULL,
  `create_time` int(11) NOT NULL DEFAULT '0',
  `update_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='栏目表';

-- ----------------------------
-- Records of $prefix$website_server
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for $prefix$website_setting
-- ----------------------------
DROP TABLE IF EXISTS `$prefix$website_setting`;
CREATE TABLE `$prefix$website_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '网站设置ID',
  `seller_id` int(11) NOT NULL DEFAULT '1' COMMENT '商户ID',
  `website_id` int(11) NOT NULL DEFAULT '0' COMMENT '网站ID',
  `lang` varchar(255) DEFAULT 'zh' COMMENT '语言',
  `setting` text NOT NULL COMMENT '网站设置',
  `create_time` int(11) NOT NULL DEFAULT '0',
  `update_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='网站设置表';

-- ----------------------------
-- Records of $prefix$website_setting
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
